/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 vote276 views1 answer
Sql value exists in column
SQL
3 votes300 views1 answer
Postgres select max value
SQL
0 vote320 views2 answers
Remove mysql workbench ubuntu
SQL
3 votes263 views2 answers
Oracle for loop
SQL
0 vote272 views1 answer
Compare if is null sql
SQL
1 vote282 views2 answers
Sql now - 1 day
SQL
3 votes292 views2 answers
Postgres download
SQL
0 vote281 views1 answer
How to combine rows in sql server procedure
SQL
0 vote278 views1 answer
Liquibase update row
SQL
0 vote291 views1 answer
How to start my sql server on mac
SQL

Share