/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 vote198 views1 answer
Mysql create table columns with spaces
SQL
3 votes205 views1 answer
Oracle user privileges
SQL
0 vote199 views1 answer
Show database not empty tables postgres
SQL
0 vote152 views1 answer
Oracle sql developer script output limit
SQL
0 vote241 views1 answer
How to check oracle index table
SQL
5 votes418 views2 answers
How to ascending order in sql
SQL
0 vote194 views1 answer
How to check if there is no database schema
SQL
9 votes218 views3 answers
Import DB through mysql console
SQL
0 vote215 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
3 votes204 views1 answer
Get current month last date in sql server
SQL

Share