Index_Unique

Indicates if an index is unique.

Supported By

• SQL Drivers (SQL Server, DB2, and ODBC)

Value

• YES
• NO

Associated Attribute

• DF_INDEX_UNIQUE (Boolean)

Remarks

SQL supports both unique and non-unique indexes. Setting the keyword to YES indicates the index is unique; setting it to NO indicates the index is non-unique. Using non-unique indexes may give unexpected results while finding records using that index.

See Also

• Column Keywords
• Index Keywords
• Table Keywords