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

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
database_name
user_name
The name of the containing database or user for table_name if different from the current database.
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.