15.00 - 9432 Immediately alter table to have a unique primary index. - 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)

9432 Immediately alter table to have a unique primary index.

Explanation:

The user created a USI on the same column set as the NUPI either through ALTER TABLE adding a new PK constraint or through CREATE UNIQUE INDEX. This results in the CREATE TABLE definition in SHOW TABLE being not valid.

Generated By:

OPD.

For Whom:

End User.

Notes:

The request is still processed despite the warning.

Remedy:

User needs to alter/recreate table using UPI instead of NUPI.