Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » SQL dialects and compatibility » Transact-SQL-compatible databases

 

Creating a Transact-SQL-compatible database (Sybase Central)

You can use Sybase Central to create a Transact-SQL-compatible database.

Prerequisites

By default, you must have the SERVER OPERATOR system privilege. The required privileges can be changed by using the -gu database server option.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Click Tools » SQL Anywhere 16 » Create Database.

  3. Follow the instructions in the wizard.

    On the Specify Additional Settings screen, click Emulate Adaptive Server Enterprise and then click Next.

  4. Follow the remaining instructions in the wizard.

Results

A Transact-SQL-compatible database is created. The database is blank padded and case sensitive, and it does not contain the SYS.SYSCOLUMNS and SYS.SYSINDEXES system views.

 See also