Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SET UNIQUE Command
Collapse the table of content
Expand the table of content

SET UNIQUE Command

Visual Studio .NET 2003

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.

Remarks

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.

See Also

INDEX | REINDEX | SET DATASESSION

Show:
© 2015 Microsoft