/SQL/How to drop a unique constraint in sql

How to drop a unique constraint in sql

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

Similar codes

0 vote175 views2 answers
How to get json data mysql
SQL
4 votes172 views1 answer
Find tables with column name in sql
SQL
0 vote159 views1 answer
What is the essence of SQL?
SQL
0 vote162 views1 answer
Mysql jdbc timezone
SQL
3 votes168 views2 answers
Find the median in sql
SQL
0 vote163 views1 answer
How to find top 3 salary in sql
SQL
0 vote178 views1 answer
How to set sql_mode for a query in CI model
SQL
60 votes300 views6 answers
Add column in sql
SQL
0 vote191 views1 answer
Joomla execute raw sql
SQL
2 votes169 views1 answer
Update with join sql server
SQL

Share