ODBC Named Indexes - ODBC Driver for Teradata - 16.20

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K
Using this feature is not recommended, because it is deprecated.

ODBC index-name grammar is supported on a per workstation basis for the following:

CREATE INDEX
DROP INDEX
DROP TABLE
SQLStatistics()

For example,

CREATE INDEX myindex ON mytable (column1, column2)

ODBC grammar ASC and DESC column-identifier clauses for CREATE INDEX are ignored since Teradata does not support this type of indexing. It is possible to DROP an index using the index-name which was specified when it was created, provided you are working on the same PC and the IndexName entry in the Registry file has not been reused.

The specified index-name need not exist on the PC; it is not relevant to Teradata because an index is created for the specified table using the standard index grammar.

For example,

CREATE INDEX (columnname(s)) ON tablename

If the named index has been deleted from the Registry, or if a user is on a different PC, the index needs to be DROPped using the Teradata grammar by specifying the tablename and columns that make up the index. For example,

DROP INDEX (columnname(s)) ON tablename

You cannot DROP a Teradata named index (for example, TableName004).