Results of Defining Structures Using SQL Statements › CREATE INDEX Statement

CREATE INDEX Statement

CREATE INDEX index-name (column-list)

Creates a key for one or more columns of a table as specified in the statement. The following are the significant KEY entity-occurrence attributes defined:

• AGR-SQLNAME= The SQL name of the table.
• AUTHID= The schema (authorization identifier) of the table.
• DATACOM-ID= An available 3-digit ID selected by Datadictionary for uniqueness within the database.
• DATACOM-NAME= The 5-character value specified with the optional DATACOM NAME parameter in the CREATE INDEX statement or SQ followed by three digits selected by Datadictionary for uniqueness within the database.
• ENTITY-NAME= The index-name specified in the CREATE INDEX statement.
• FOREIGN=N
• INCLUDE-NIL-KEY=Y
• MASTER-KEY=N
• MAX-KEY-LENGTH=0
• NATIVE-KEY=N
• SQLNAME= The index-name provided on the CREATE INDEX statement.
• UNIQUE=N