In addition to the DDL differences discussed previously, note these:
In a DELETE/DROP or PRIMARY KEY clause of an ALTER TABLE statement, Sybase IQ takes the RESTRICT action (reports an error if there are associated foreign keys). Adaptive Server Anywhere always takes the CASCADE action.
Similarly, DROP TABLE statement reports an error in Sybase IQ if there are associated foreign-key constraints.
Sybase IQ does not support these DDL statements: CREATE COMPRESSED DATABASE, CREATE TRIGGER, SETUSER.
Sybase IQ supports referential integrity at the statement level, rather than the transaction-level integrity that Adaptive Server Anywhere supports with the CHECK ON COMMIT clause of CREATE TABLE statement.
A Sybase IQ table cannot have a foreign key that references an Adaptive Server Anywhere (or Catalog) table, and an Adaptive Server Anywhere table cannot have a foreign key that references a Sybase IQ table.
In CREATE DATABASE, the defaults for case sensitivity and collation differ. The defaults for Sybase IQ are CASE RESPECT and the ISO_BINENG collation; for Adaptive Server Anywhere, the defaults are CASE IGNORE, and collation inferred from the language and character set of the operating system.
