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 (command line)

You can use the command line to create a Transact-SQL-compatible database. The remainder of the section describes which options you need to set.


There are no prerequisites for this task.

  • Run the following dbinit command:

    dbinit -b -c -k -dba DBA,sql db-name.db

    In this command, -b blank pads the database, -c makes the database case sensitive, and -k prevents the SYS.SYSCOLUMNS and SYS.SYSINDEXES system views from being created.


A Transact-SQL-compatible database is created.

 See also