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

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.