15.10 - DROP HASH INDEX - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Release Date
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

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