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.

Prérequis

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.

Résultat

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
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0