Drops the join index.
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
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