/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

1 vote188 views3 answers
How to get date in sql
SQL
0 vote178 views1 answer
Mysql date time string format python
SQL
0 vote182 views1 answer
How to select an index in oracle sql
SQL
0 vote181 views2 answers
Get all index postgres
SQL
0 vote187 views1 answer
Odd record sql query
SQL
2 votes192 views2 answers
Run mysql command from bash
SQL
0 vote185 views1 answer
Postgres data location
SQL
17 votes187 views4 answers
Sort by mysql
SQL
0 vote147 views0 answer
SQL
0 vote179 views1 answer
Get cpu details sql
SQL

Share