/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 vote306 views1 answer
How to insert same table data using mysql query
SQL
2 votes326 views1 answer
Merge two columns in sql oracle
SQL
0 vote324 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote332 views1 answer
Add column in sql server ubuntu
SQL
16 votes344 views1 answer
Mysql smallint range
SQL
0 vote335 views1 answer
Executescalar in sql server
SQL
-1 vote389 views1 answer
Difference berween database and data base management system
SQL
3 votes428 views1 answer
Oracle cannot access v$session
SQL
61 votes535 views6 answers
Mysql add column
SQL
1 vote371 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL

Share