"C. Using UNIQUE constraints
UNIQUE constraints are used to enforce uniqueness on nonprimary key
columns. The following example enforces a restriction that the Name
column of the Product table must be unique.
Copy Code
Name nvarchar(100) NOT NULL
UNIQUE NONCLUSTERED