/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 vote199 views4 answers
Open mysql port bitnami tomact
SQL
0 vote188 views1 answer
Search mysql database for column
SQL
1 vote229 views2 answers
Changes not showing on website server odoo
SQL
0 vote142 views1 answer
Check sql query executed wp
SQL
15 votes186 views2 answers
How to drop database name in postgresql
SQL
0 vote201 views1 answer
Change filed order in mysql
SQL
0 vote189 views2 answers
Mysql get routine parameter list
SQL
0 vote187 views1 answer
Oracle webcenter content search enginer
SQL
5 votes226 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote214 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL

Share