Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

SET UNIQUE Command

Specifies whether records with duplicate index key values are maintained in an index file.


SET UNIQUE ON | OFF

Parameters

ON

Specifies that any record with a duplicate index key value not be included in the index file. Only the first record with the original index key value is included in the index file.

OFF

(Default) Specifies that records with duplicate index key values be included in the index file.

An index file retains its SET UNIQUE setting when you issue REINDEX. For more information, see INDEX and REINDEX.

SET UNIQUE is scoped to the current data session.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.