Skip to content

Latest commit

 

History

History
25 lines (20 loc) · 995 Bytes

create-index-statement.md

File metadata and controls

25 lines (20 loc) · 995 Bytes
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
CREATE INDEX Statement
CREATE INDEX Statement
David-Engel
v-davidengel
01/19/2017
sql
connectivity
reference
CREATE INDEX [ODBC]
SQL grammar [ODBC], create index

CREATE INDEX Statement

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.