table_specification - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

table on which the secondary index is to be dropped.

The named table cannot be one of the following table types.

  • global temporary function trace
  • journal
  • volatile
TEMPORARY
You are dropping an index on a materialized global temporary table.
You can only specify this keyword when dropping an index on a global temporary table.
If you do not specify TEMPORARY, and table_name identifies a global temporary table, then the request is applied to the base global temporary table.
There must not be any materialized instances of the named table or you cannot drop the index on the base global temporary table.
database_name
The name of the containing database for table_name if different from the current database.
table_name
The table on which index_name is defined.