17.10 - Related Information - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

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.

For information about Teradata Unity, see the Teradata Unity documentation.