In addition to the DDL differences discussed previously:
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). SQL 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 SQL Anywhere supports with the CHECK ON COMMIT clause of the CREATE TABLE statement.
A Sybase IQ table cannot have a foreign key that references a SQL Anywhere (or catalog) table, and a SQL Anywhere table cannot have a foreign key that references a Sybase IQ table.
In a Sybase IQ database, publications can only be created on SQL Anywhere tables.
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 SQL Anywhere, the defaults are CASE IGNORE, and collation inferred from the language and character set of the operating system.
Sybase IQ does not support the CREATE ENCRYPTED DATABASE and CREATE DECRYPTED DATABASE commands supported by SQL Anywhere. See Advanced Security in Sybase IQ.
