15.00 - 3516 More than one primary index or primary key specified. - 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)

3516 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.

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.