15.00 - Guidelines for NoPI Tables - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Guidelines for NoPI Tables

If you specify an explicit PRIMARY KEY constraint, UNIQUE constraint, or both for an explicitly defined NoPI table, Teradata Database redefines those constraints as USIs, as you can see if you submit a SHOW TABLE request for such a table.