CREATE and DROP INDEX

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

CREATE INDEX is supported in ODBC syntax as well as in Teradata syntax. DROP INDEX is supported in Teradata syntax as well as ODBC syntax for locally created index names. For example, it is possible to drop an index using the index name in which it was created, provided you are working on the same client system where it was created. However, you cannot drop an index using the Teradata internal named index convention (for example, TableName004).

Using this feature is not recommended, because it is deprecated. For details, see“ODBC-Style Named Indexes (deprecated in 15.00)”.