15.10 - DROP JOIN INDEX - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Purpose

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

Syntax