15.10 - ON Table - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
Content Type
Programming Reference
Publication ID
English (United States)
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.
Name of the containing database for table_name, if other than the current database.
Name of the containing user for table_name, if other than the current user.
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