/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

10 votes182 views3 answers
Sql check double value
SQL
2 votes195 views3 answers
How to get second highest salary in each department in sql
SQL
17 votes239 views2 answers
How to assign date field for table in mysql
SQL
0 vote210 views1 answer
Time in sql server
SQL
1 vote198 views1 answer
Sql and
SQL
0 vote178 views2 answers
How to generate a unique random number in mysql
SQL
11 votes176 views2 answers
Insert current date sql
SQL
0 vote170 views1 answer
Pgsql is not permitted to log in
SQL
0 vote183 views1 answer
Postgresql inheritance
SQL
12 votes190 views1 answer
Run mysql instance in docker
SQL

Share