Progress
SQL-89
Guide and Reference


CREATE INDEX Statement

Creates an index on a table that was created using the SQL Data Definition Language.

SYNTAX
CREATE 
  [ UNIQUE ] INDEX index-name
  ON table-name ( column [ , column ] ) 

[ UNIQUE ]

Indicates that all values in the specified column or combination of columns must be unique.

INDEX index-name

The name you want to assign to the index. The index name must be unique within the database, not just within the table.

ON table-name

The name of the table that contains the column or columns you want to index. This table must have been created with the SQL Data Definition Language.

column

The name of a column that you want to index. You can define an index on one or more columns.

EXAMPLE

This example creates the num index.

CREATE UNIQUE INDEX num 
  ON Cust_Table (Cust_Num). 

NOTES

All columns in a UNIQUE index must be NOT NULL. 

SEE ALSO

DROP INDEX Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095