15.10 - Table Name - 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

Name of the base table on which the hash index is defined.

You cannot define a hash index on any of the following database objects:
  • Column-partitioned tables
  • Global temporary tables
  • Global temporary trace tables
  • Hash indexes
  • Join indexes
  • Journal tables
  • NoPI tables
  • Queue tables
  • Views (neither recursive nor nonrecursive)
  • Volatile tables

Note that you cannot create a hash index on a PPI table if the partitions for the table are defined on PERIOD bound functions.

database_name
user_name

Name of the containing database or user for table_name if other than the containing database or user specified for hash_index_name.