15.00 - 3968 Cannot drop an unique secondary index which is also a Parent Key. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

3968 Cannot drop an unique secondary index which is also a Parent Key.

Explanation:

The user tried to drop an unique secondary index which is also defined as a Parent Key. Note that by definition, the Parent Key (i.e. referenced column(s)) must be defined with unique constraint.

Generated By:

OPT modules.

For Whom:

End User.

Remedy:

The user must drop the referential constraint which has the target secondary index as the Parent Key, and then resubmit the request.