Data Definition Language

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

• 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
  SAP 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 SAP Sybase IQ.
• Considerations When Using the CREATE INDEX Statement
  CREATE INDEX syntax differs slightly between Adaptive Server Enterprise, SQL Anywhere, and SAP Sybase IQ.
• Users, Groups/Roles, and Permissions
  There are some differences between the Adaptive Server Enterprise and SQL Anywhere and SAP Sybase IQ models of users and roles/groups.
• Load Formats
  Load format support differs between Adaptive Server Enterprise, SQL Anywhere, and SAP Sybase IQ.
• Options for Transact-SQL Compatibility
  Set SAP Sybase IQ database options using the SET OPTION statement.