/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

7 votes112 views2 answers
Mysql get year from date
SQL
0 vote118 views1 answer
Hex string sql becomes int64
SQL
0 vote132 views1 answer
Oracle job session
SQL
0 vote118 views1 answer
How to find unique element in sql
SQL
0 vote128 views1 answer
Oracle current date minus 1 day
SQL
1 vote114 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
2 votes109 views2 answers
Sql percentage
SQL
0 vote107 views3 answers
CONTACT FORM SQL
SQL
2 votes122 views1 answer
Capitalize 1st letter in sql server
SQL
1 vote116 views1 answer
Postgres install unaccent extension
SQL

Share