CREATE INDEX Statement

  • Article

The syntax of the CREATE INDEX statement is:

CREATE [UNIQUE] INDEX index-name ON table-name (column-identifier [ASC][DESC][, column-identifier [ASC][DESC]...]) WITH <index option list>

where <index option list> can be: PRIMARY | DISALLOW NULL | IGNORE NULL

Only the Microsoft Access driver uses the DISALLOW NULL and IGNORE NULL index options. The dBASE and Paradox drivers accept the syntax, but ignore the presence of either option.

When the Paradox driver is used, the CREATE INDEX statement creates Paradox primary key files and secondary files.

This statement is not supported by the Microsoft Excel or Text drivers.