15.10 - ON Table - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K
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