Drops a hash index on a table.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
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