Teradata Database Message 3968 - 3968 - Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
Teradata® Vantage™
Message
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.
Notes
None
Remedy
The user must drop the referential constraint which has the target secondary index as the Parent Key, and then resubmit the request.