/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 vote266 views2 answers
How to get json data mysql
SQL
-1 vote309 views1 answer
Difference berween database and data base management system
SQL
4 votes263 views2 answers
Oracle default date format
SQL
0 vote277 views1 answer
Call scalar valued function sql
SQL
0 vote260 views1 answer
Sql search all columns of database oracle sql
SQL
6 votes255 views5 answers
Get current date sql
SQL
0 vote278 views1 answer
Sql script get all stored procedures from database
SQL
1 vote291 views1 answer
What is in condition in sql
SQL
14 votes273 views1 answer
Sql value of string
SQL
0 vote258 views1 answer
Postgressql uuid
SQL

Share