Recreate a Table | Database Administration | VantageCloud Lake - Recreating a Table - 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
You may need to recreate a data table to:
  • Change a default PI to a defined PI for a nonempty table.
  • Add or remove a PI for a nonempty table.
  • Change the PI to a different PI for a nonempty table.
  • Change a NUPI to a UPI in a populated table when there is no USI (however, typically you create the USI on the table and then alter it).
  • Redefine the partitioning of a populated table. You may still be able to use ALTER TABLE.
  • Change a data type attribute that affects existing data. For rules on changing data types, see ALTER TABLE.
  • Define or delete COMPRESS storage attributes for an existing column.
  • Add columns in excess of the maximum for the number of columns defined during the life of a table.
  • Move the table to another database or user.
  • Change the groupings of columns into column partitions.
Access a table using a view, especially for tables used by multiple users.

Use the SHOW TABLE or SHOW IN XML TABLE request to display the current table definition, which you can then modify and submit.