/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

0 vote104 views1 answer
Learn sqlite dart
SQL
0 vote129 views1 answer
Drop column from table if exist on live server mysql
SQL
4 votes116 views4 answers
Update select mysql
SQL
0 vote110 views1 answer
How to check which sp is running in sql server
SQL
3 votes117 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote110 views1 answer
Dbms_output sql developer
SQL
0 vote122 views2 answers
Mysql insert into multiple tables
SQL
1 vote122 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
5 votes112 views4 answers
Rollback to in sql
SQL
2 votes136 views2 answers
Set value to null sql
SQL

Share