SAP SQL Anywhere and SAP Sybase IQ have differences in DDL behavior.
In a DELETE/DROP or PRIMARY KEY clause of an ALTER TABLE statement, SAP Sybase IQ takes the RESTRICT action (reports an error if there are associated foreign keys). SAP SQL Anywhere always takes the CASCADE action.
Similarly, DROP TABLE statement reports an error in SAP Sybase IQ if there are associated foreign-key constraints.
SAP Sybase IQ does not support these DDL statements: CREATE COMPRESSED DATABASE, CREATE TRIGGER, SETUSER.
SAP Sybase IQ supports referential integrity at the statement level, rather than the transaction-level integrity that SAP SQL Anywhere supports with the CHECK ON COMMIT clause of the CREATE TABLE statement.
A SAP Sybase IQ table cannot have a foreign key that references a SAP SQL Anywhere (or catalog) table, and a SAP SQL Anywhere table cannot have a foreign key that references a SAP Sybase IQ table.
In a SAP Sybase IQ database, publications can only be created on SAP SQL Anywhere tables.
In CREATE DATABASE, the defaults for case-sensitivity and collation differ. The defaults for SAP Sybase IQ are CASE RESPECT and the ISO_BINENG collation; for SAP SQL Anywhere, the defaults are CASE IGNORE, and collation inferred from the language and character set of the operating system.
SAP Sybase IQ does not support the CREATE ENCRYPTED DATABASE and CREATE DECRYPTED DATABASE commands supported by SAP SQL Anywhere. See Administration: User Management and Security.