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