table_specification - Teradata Vantage - Analytics Database
SQL Data Definition Language Syntax and Examples
- Deployment
- VantageCloud
- VantageCore
- Edition
- VMware
- Enterprise
- IntelliFlex
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2025-11-22
- dita:mapPath
- jco1628111346878.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- mdr1472255012272
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- TEMPORARY
- The table is a global temporary table and the index is being created on its instance in the current session.
- If you do not specify TEMPORARY, the index is created on the base global temporary table definition. In this case, if there are materialized instances of the table you cannot create the index on the base global temporary table.
- Temporary tables cannot be specified for geospatial indexes.
- If you specify TEMPORARY against a permanent table, the system returns an error.
- You cannot create indexes of any kind on a volatile table.
- database_name
- Name of the containing database for table_name, if other than the current database.
- user_name
- Name of the containing user for table_name, if other than the current user.
- table_name
- Table for which an index is to be created.
- You cannot specify any of the following:
- Derived table
- Hash index
- Journal table
- Ordinary view
- Recursive view
- Volatile table