Related Information - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-22
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

For more information about table definitions and primary index partitioning, see CREATE TABLE and CREATE TABLE AS and CREATE TABLE (Queue Table Form) and Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.

You can use the ALTER TABLE TO CURRENT statement to reconcile the partitioning of a partitioned primary index for a temporal table or uncompressed join index defined on a temporal table. See ALTER TABLE TO CURRENT.

For more information about partitioned primary indexes and the system-derived PARTITION and PARTITION#Ln columns, see Teradata Vantage™ - Database Design, B035-1094.

For information about the various forms of partition elimination, see Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.

For information about using ALTER TABLE to modify temporal tables, see Teradata Vantage™ - Temporal Table Support, B035-1182.