15.10 - DROP HASH INDEX - 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

Purpose

Drops a hash index on a table.

Required Privileges

You must have either of the following sets of privileges to drop a hash index:
  • DROP TABLE on the join index
  • INDEX or DROP TABLE on at least one of the base tables

Syntax