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