17.00 - NO PRIMARY - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

The table is defined without a primary index or primary AMP index.

You cannot specify a column name list following a NO PRIMARY INDEX specification.

If the preceding item in the index list is a partitioning clause that is not part of an index clause, you must specify a COMMA character preceding NO PRIMARY INDEX. Otherwise, the comma is optional.

For the complete set of rules that control primary index defaults, see Teradata Vantage™ - Database Design, B035-1094.

Optional keyword you can include for readability.