17.10 - table_specification - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
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