Previous Topic: Deleting a Column from a KeyNext Topic: Updating Table Attributes

Maintaining Tables with Related Constraints › Impact of Changing Structure Definitions on Constraints › Deleting Keys

Deleting Keys

If you delete a key with constraints defined, there is no effect on Check constraints, however, Foreign and Unique constraints become obsolete.

Type of
Constraint


Effect on Constraint

Check

Not applicable.

Foreign and
Unique

CA Datacom Datadictionary generates a DSF return code CON when you attempt to delete a key related to one of these type of constraints. Drop the constraint before deleting the key.