Drops the join index.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Other SQL dialects support similar non-ANSI standard statements with names such as the following:
- DROP MATERIALIZED VIEW
Required Privileges
You must have either of the following sets of privileges to drop a join index:
- DROP TABLE on the join index
- INDEX or DROP TABLE on at least one of the base tables