Data Definition Language

Differences exist between Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ in how you create databases and database objects.

• Creating a Transact-SQL Compatible Database from Sybase Central
  Create a Transact-SQL compatible database with case sensitivity settings that emulate Adaptive Server Enterprise.
• Creating a Transact-SQL Compatible Database Using the CREATE DATABASE statement
  Use Interactive SQL to create a Transact-SQL compatible database.
• Case-sensitivity
  Case-sensitivity in databases refers to the case-sensitivity of data, identifiers, and passwords.
• Ensuring Compatible Object Names
  Each database object must have a unique name within a certain name space.
• Considerations When Using the CREATE TABLE Statement
  When creating tables for compatibility, be aware of the following compatibility considerations for NULL treatment, check constraints, referential integrity, default values, identify columns, computed columns, temporary tables, and table location.
• Considerations When Using the CREATE DEFAULT, CREATE RULE, and CREATE DOMAIN Statements
  Sybase IQ provides an alternative means of incorporating rules.
• Considerations When Using the CREATE TRIGGER Statement
  Support for triggers differs between Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ.
• Considerations When Using the CREATE INDEX Statement
  CREATE INDEX syntax differs slightly between Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ.
• Users, Groups, and Permissions
  There are some differences between the Adaptive Server Enterprise and SQL Anywhere and Sybase IQ models of users and groups.
• Load Formats
  Load format support differs between Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ.
• Options for Transact-SQL Compatibility
  Set Sybase IQ database options using the SET OPTION statement.