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 (SQL)

You can use SQL 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. Connect to any SQL Anywhere database.

  2. Enter the following statement in Interactive SQL:

    CREATE DATABASE 'db-name.db'
    DBA USER 'DBA' DBA PASSWORD 'sql'
    ASE COMPATIBLE
    CASE RESPECT 
    BLANK PADDING ON;

    In this statement, the ASE COMPATIBLE clause prevents the SYS.SYSCOLUMNS and SYS.SYSINDEXES system views from being created.

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