/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

4 votes176 views1 answer
Postgresql change default value
SQL
0 vote155 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote153 views1 answer
Get only one row in mysql
SQL
1 vote169 views1 answer
Mysql sort by date column
SQL
0 vote138 views1 answer
How to print mysql query of codeigniter query builder
SQL
1 vote138 views1 answer
Cross schema query oracle 2 users
SQL
0 vote128 views1 answer
Insert thai language sql server
SQL
3 votes140 views2 answers
Sql server current date without time
SQL
4 votes207 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote185 views1 answer
Php insert null mysql
SQL

Share