CREATE and DROP INDEX - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
smj1488824663219.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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)”.