Altering Subtables and Supertables

Two considerations apply to typed tables that are part of inheritance hierarchies:

For subtables, ADD CONSTRAINT and DROP CONSTRAINT are not valid on inherited constraints.
For supertables, ADD CONSTRAINT and DROP CONSTRAINT propagate to all subtables.

For discussions of data-integrity constraints and the ON DELETE CASCADE option, see the IBM Informix Guide to SQL: Tutorial.

For a discussion of database and table creation, see the IBM Informix Database Design and Implementation Guide.

For information on how to maximize performance when you make table modifications, see your IBM Informix Performance Guide.