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.

Prerequisites

There are no prerequisites for this task.

 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.

Results

A Transact-SQL-compatible database is created.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0