René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Teradata SQL: CREATE TABLE

create table table_1 (....)

Specifying primary index

All teradata tables must have a primary index.
The following clauses can be appened to the create table statement to specify the primary index:
  • UNIQUE PRIMARY INDEX
    creates a unique primary index (UPI).
  • PRIMARY INDEX
    creates a non-unique primary index (NUPI).
  • UNIQUE INDEX
    creates a unique secondary index (USI).
  • INDEX
    creates a non-unique secondary index (NUSI).
    A non-unique secondary index can also be created using create index.