/SQL/Drop unique key constraint in sql server

Drop unique key constraint in sql server

How to drop a unique constraint in sql

SHOW CREATE TABLE [tableName]
-- Find the constraintID after CONSTRAINT 'constraintID'
ALTER TABLE [tableName] DROP FOREIGN KEY constraintID

1

Drop unique key constraint in sql server

/* To Drop Unique Key Constraint*/
ALTER TABLE Table_Name
DROP CONSTRAINT Constraint_Name

0

Remove unique key from a table

example: alter table DropIndex drop index BookId ;

0

Similar codes

4 votes183 views1 answer
Install postgres 12 on ubuntu
SQL
2 votes226 views1 answer
How to show the whole table in sql
SQL
0 vote232 views1 answer
Vbscript connect mssql
SQL
1 vote209 views1 answer
Input in mysql
SQL
0 vote221 views1 answer
How to fetch unique records from two tables
SQL
-1 vote219 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote213 views1 answer
Not between mysql
SQL
3 votes225 views1 answer
Oracle user privileges
SQL
0 vote208 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote212 views1 answer
Java input type sql date
SQL

Share