Teradata Database Message 3516 - 3516 - Analytics Database - Teradata Vantage

Message

More than one primary index or primary key specified.

Explanation

Tables can have only one primary index and one primary key. The user can add a primary key if and only if there's not already a primary key exist in table.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Decide which index will be the primary index. The other indexes can be redefined as secondary. Resubmit the request. In the case of a primary key, the user must take either of the following steps: <1> If the current primary key is mapped to an unique secondary index then drop the primary key using DROP INDEX and resubmit the request. <2> If the current primary key is mapped to an unique primary index then define this index as an unique secondary index using CREATE INDEX statement.