15.00 - 5321 Constraint, primary index, or secondary index with the same name "%VSTR" already exists in table. - 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)

5321 Constraint, primary index, or secondary index with the same name "%VSTR" already exists in table.

Explanation:

The constraint, primary index, or secondary index name must be unique in a table regardless of constraint type.

Generated By:

RES and OPT modules.

For Whom:

End User.

Notes:

Names of join indexes and hash indexes must be unique within a database. For example, a join index must not have the same name as a table in the same database but it may have the same name as a constraint, primary index, or secondary index as in a table on which the join index is defined.

Remedy:

Give the constraint or index a different name and resubmit the request.