Add unique constraint in SQL Server 2008 GUI?

sql sql-server ssms sql-server-2008
mezamorphic picture mezamorphic · Nov 30, 2012 · Viewed 45.1k times · Source

I have an existing table with data. I have just added a new column but I cannot find how to add a unique constraint on that column. Could someone please advise? Right-clicking and selecting "check constraints" wasn't helpful.

Answer

marc_s picture marc_s · Nov 30, 2012

You need to right-click in the table designer and pick Indexes/Keys:

enter image description here

Then a dialog pops up and you can add a new index to the list of indices (on the left hand side) and define it to be a unique index:

enter image description here

Related questions

SQL Server 2008: how do I grant privileges to a username?

I need to be able to establish an ODBC connection through SQL Server authentication. In SSMS how do I grant permission for a user to be able to have ALL RIGHTS on a specific database? is there a way to …

Read More
How do I grant myself admin access to a local SQL Server instance?

I installed SQL Server 2008 R2 to my local machine. But, I can't create a new database because of rights (or lack of). "CREATE DATABASE PERMISSION DENIED" So, I tried to assign the admin privileges to my current login "User does …

Read More
Converting Select results into Insert script - SQL Server

I have SQL Server 2008, SQL Server Management Studio. I need to select data from Table1 in database1. Then I have to edit some values in the results and insert values into Table1 in database2. Or let me put it other …

Read More