Teradata Database Message 9432 - 9432 - Analytics Database - Teradata Vantage

Message

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.