16.20 - DROP INDEX - 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
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

Purpose

Drops a secondary index on a table or join index.

You can drop a named index by specifying the index name or index definition.

When you drop a secondary index, the system frees the disk space that was used by the index and removes information about the index from the table header. If statistics have been collected on the index, the system sets the value for the IndexNumber column in DBC.StatsTbl to 0, but does not drop the statistics that have been collected on the index column.

Required Privileges

You must have the INDEX or DROP TABLE privilege on the table.

To drop an index from a join index, you must have one of the following privileges.

  • DROP TABLE on the join index
  • DROP TABLE on one of the base tables
  • INDEX on the join index
  • INDEX on one of the base tables

Syntax DROP index_name



Syntax DROP index_definition