/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 vote264 views1 answer
Sql row having max
SQL
0 vote249 views1 answer
SQL SERVER xquery count child nodes
SQL
4 votes242 views1 answer
Find tables with column name in sql
SQL
0 vote236 views4 answers
Convert databse to achieve log mode oracle
SQL
10 votes228 views1 answer
Dba_dependencies
SQL
0 vote230 views1 answer
Mysql find missing values
SQL
2 votes229 views2 answers
Mamp connect mysql terminal
SQL
2 votes258 views1 answer
Oracle block
SQL
0 vote240 views1 answer
Postgres read table structure
SQL
0 vote262 views1 answer
Implode in sql query
SQL

Share