|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
How to: Restrict a Data Column to Contain Unique Values
You set ato contain unique values by adding a unique constraint to a data table. Unique constraints are also called keys. Marking a column as a Primary Key in the Dataset designer will create a Unique Constraint. For more information, see .
To constrain a column to contain unique values
Open your dataset in the Dataset Designer.
Right-click the column you want to constrain to unique values. Point to Add, and then click Key.
Verify that the correct column is selected in the Unique Constraint dialog box.
Replace the default name of the constraint with a more meaningful name, if desired. For more information, see.