Modifying Indexes, CALC Keys, and Referential Constraints › Maintaining Referential Constraints › Dropping a Referential Constraint

Dropping a Referential Constraint

To drop an unlinked referential constraint, or a linked referential constraint, use the SQL DDL DROP CONSTRAINT statement.

Considerations

If you drop a clustered constraint, the location mode of the referencing table will change as follows:

• If a default index exists, CA IDMS/DB will use it as the clustering index.
• Otherwise, it uses a direct location mode which means that all new rows will be stored in the first page containing enough space to hold the row.

Example

In the following example, the EMP_BENEFITS constraint is removed from the BENEFITS table:

drop constraint emp_benefits from benefits;