ALTER TABLE Related Information

ALTER TABLE Related Information - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

ft:locale

en-US

ft:lastEdition

2024-12-11

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

For more information about table definitions and primary index partitioning:

CREATE TABLE and CREATE TABLE AS
CREATE TABLE (Queue Table Form)

For information about using 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: ALTER TABLE TO CURRENT

For more information about partitioned primary indexes: Advantages and Disadvantages of Partitioned Primary Indexes

For information about partition elimination:

Column Partition Elimination
Delayed Row Partition Elimination
Dynamic Row Partition Elimination
Row Partition Elimination
Static Row Partition Elimination