DROP INDEX SQL Statement | VantageCloud Lake - DROP INDEX - Teradata VantageCloud Lake

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.

• DROP INDEX Syntax
• DROP INDEX Syntax Elements
• DROP INDEX Usage Notes
• DROP INDEX Examples

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Required Privileges

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