Background documentation-7066: Unique index referenced by foreign key not allowed Locate this document in the navigation structure

 

Explanation

The specified index cannot be dropped, because the columns it contains were specified as referenced columns of the referenced table in a referential CONSTRAINT definition.

User Response

You can only delete the index after you have deleted the corresponding referential CONSTRAINT definition. You can use a QUERY statement based on the DOMAIN.FOREIGNKEYCOLUMNS system table to display the CONSTRAINT definitions that were generated.