Creating a Transact-SQL-compatible database

This section describes choices you must make when creating or rebuilding a database.

Quick start

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

Enter the following statement, for example, in Interactive SQL:
```
CREATE DATABASE 'db-name.db'
CASE RESPECT BLANK PADDING ON
```