How to drop a unique constraint from table column?

sql database sql-server-2005 unique-constraint non-clustered-index
SKINDER picture SKINDER · Mar 31, 2011 · Viewed 105.8k times · Source

I have a table 'users' with 'login' column defined as:

[login] VARCHAR(50) UNIQUE NOT NULL

Now I want to remove this unique constraint/index using SQL script. I found its name UQ_users_7D78A4E7 in my local database but I suppose it has a different name on another database.

What is the best way to drop this unique constraint? Or at least any...

Thanks.

Answer

Avadhesh picture Avadhesh · Mar 31, 2011 
ALTER TABLE users
DROP CONSTRAINT 'constraints_name'

Related questions

How to check which locks are held on a table

How can we check which database locks are applied on which rows against a query batch? Any tool that highlights table row level locking in real time? DB: SQL Server 2005

Read More
Querying data by joining two tables in two database on different servers

There are two tables in two different databases on different servers, I need to join them so as to make few queries. What options do I have? What should I do?

Read More
Find stored procedure by name

Is there any way I can find in SQL Server Management Studio stored procedure by name or by part of the name? (on active database context) Thanks for help

Read More