DROP JOIN INDEX SQL Statement | Teradata Vantage - 17.00 - DROP JOIN INDEX - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

Drops the join index.

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