This section describes choices you must make when creating or rebuilding a database.
Here are the basic steps you need to take to create a Transact-SQL-compatible database. The remainder of the section describes which options you need to set.
Creating a Transact-SQL compatible database from
Sybase Central
One page of the Create Database wizard is named Default Database Attributes.
To emulate Adaptive Server Enterprise, choose “Emulate Adaptive Server Enterprise” which automatically selects Case sensitivity for string comparisons and Case sensitivity for passwords.
Creating a Transact-SQL compatible database using
the CREATE DATABASE statement
Type the following statement, for example, in Interactive SQL:
CREATE DATABASE 'db-name.db'
CASE RESPECT BLANK PADDING ON
