DROP INDEX Syntax | Teradata Vantage - DROP INDEX Syntax - Advanced SQL Engine - Teradata Database

DROP INDEX { index_specification | index_definition } [;]

index_specification

[ database_name. ] index_name
  ON { table_specification | join_index_specification }

index_definition

{ ( column_name [,...] ) | [ database_name. ] index_name }
  [ order_clause ]
  ON { table_specification | join_index_specification }

table_specification

[ TEMPORARY ] [ database_name. ] table_name

join_index_specification

[ database_name. ] join_index_name

order_clause

ORDER BY [ VALUES | HASH ] ( column_name_2 )