17.10 - Rules for Primary Indexes and Their Defaults for a Column-Partitioned Table - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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 Vantage creates the table without a primary index.