Sybase IQ 12.6 enforces column and table CHECK constraints, which you can use to allow arbitrary conditions to be verified. Column-level constraints can only reference the column on which they are defined. If the constraint also references more than one column in the table, a table constraint must be used.
The UNENFORCED keyword is no longer supported on check constraints. Supported constraints previously not enforced are now enforced on updates, inserts, and loads of new data. Constraints are not enforced on existing data. Some constraints are not supported by Sybase IQ; an error is now reported for unsupported constraints.
For restrictions and changes, see the ALTER TABLE statement, CREATE TABLE statement, and the CHECK CONSTRAINTS option on the LOAD TABLE statement in Sybase IQ Reference Manual.
If you have databases created with a previous version
of Sybase IQ, you should run the sp_iqprintconstraints procedure
to list all IQ tables and columns in a format that allows you to
recreate them after they are deleted. You can then run the sp_iqdropconstraints procedure,
if you want to drop all constraints on all IQ tables in the database.
For more information, see the chapter “Migrating Data from
Prior Versions” in your Sybase IQ Installation and Configuration Guide.
