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