CREATE ALIAS TABLE Usage - Teradata VantageCloud Lake
Lake - Manage and Move Data
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata VantageCloud Lake
- Release Number
- Published
- February 2025
- ft:locale
- en-US
- ft:lastEdition
- 2025-05-16
- dita:mapPath
- atx1683670417382.ditamap
- dita:ditavalPath
- pny1626732985837.ditaval
- dita:id
- atx1683670417382
- An alias table has Apache Iceberg format.
- 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.