16.20 - ON Table - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
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