CREATE TABLE Usage (Alias Table Form) - 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
- An alias table has Apache Iceberg format.
- By default, an alias table is created with NO PRIMARY INDEX.
- You cannot create an index for an alias table.
- You cannot use an alias table in an ALTER TABLE statement.
- HELP TABLE output is the same for a Datalake table specified as an alias table and the same table specified with dot notation.
- SHOW TABLE output for an alias table is the CREATE TABLE syntax used to create the alias table.
- An alias table has an entry in the table DBC.TVM, but no schema definition in the table DBC.TVFields or any other dictionary table.