16.20 - Rules for Primary Indexes and Their Defaults for a Column-Partitioned Table - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)
  • A column-partitioned table can have a primary index, a primary AMP index, or no primary index.
  • If you do not specify a PRIMARY INDEX or PRIMARY AMP clause or if you do specify a NO PRIMARY INDEX clause and you also specify a PARTITION BY clause, the partitioning must specify a COLUMN partitioning level.
  • If you do not specify a PRIMARY INDEX (column_list) clause, PRIMARY AMP INDEX clause, or NO PRIMARY INDEX clause explicitly in your CREATE TABLE statement, but you do specify a PARTITION BY clause, then Teradata Database creates the table without a primary index.