CREATE INDEX

Use this statement to create table (or compound) indexes, i.e. indexes that places a constraint on one or more columns. Its syntax is:

  CREATE [ UNIQUE ] INDEX index
  ON table (field [ASC|DESC][, field [ASC|DESC], ...])
  [WITH { PRIMARY | DISALLOW NULL | IGNORE NULL }]

The parts of CREATE INDEX statement have the meanings given below:

Part Meaning

index The name of the index to be created

table The name of the table being indexed

field The name of the field(s) to be indexed

UNIQUE No duplicate values are allowed.

ASC The field is indexed in ascending order

DESC The field is indexed in descending order

PRIMARY The index is the table's primary key. Note that a table may have only one primary key.

DISALLOW NULL Each data row must contain a non-null value in the indexed field(s)

IGNORE NULL Do not include data rows having a null value in the indexed fields.

[Return to SQL Syntax]

Part	Meaning
index	The name of the index to be created
table	The name of the table being indexed
field	The name of the field(s) to be indexed
UNIQUE	No duplicate values are allowed.
ASC	The field is indexed in ascending order
DESC	The field is indexed in descending order
PRIMARY	The index is the table's primary key. Note that a table may have only one primary key.
DISALLOW NULL	Each data row must contain a non-null value in the indexed field(s)
IGNORE NULL	Do not include data rows having a null value in the indexed fields.