column options in sql

[MrtforCode]

Hello, I got a question about sql. How can I create a column that values can not repeat, so there can be no identicall values in that column (just like a PK). Well I remember I can do this in MS Access by ticking one of the options, but in the sql I didn't see such an option.

[GaryMazzone]

You create a unique index on the column.

[MrtforCode]

and how to do that in SQL studio please ?

[GaryMazzone]

I do it by code.

Create Unique Index Un_Table1FirstNameLastName on Person
(FirstName,LastName)

[smendoza]

Or you can add a unique key constraint for that column during the creation of the table or alter the table and add the constraint