/SQL/Sql server remove primary key without dropping table

Sql server remove primary key without dropping table

IF EXISTS (SELECT * FROM sys.key_constraints
           WHERE type = 'PK' AND parent_object_id = OBJECT_ID('MyTable')
           AND Name = 'PK_MyTable')
    ALTER TABLE MyTable DROP CONSTRAINT PK_MyTable

Source: stackoverflow.com

Similar codes

3 votes186 views1 answer
How to add unique constraint in mysql table
SQL
0 vote182 views1 answer
SQL Cut part string
SQL
0 vote160 views1 answer
Mysql exception output
SQL
1 vote150 views3 answers
What is union in sql
SQL
0 vote171 views1 answer
Second Step in installing SQL workbench
SQL
8 votes185 views3 answers
Find table for column name in sql
SQL
9 votes169 views2 answers
Convert data type in sql
SQL
0 vote216 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote178 views1 answer
How to get table id sequence postgres
SQL
12 votes162 views4 answers
How to check mysql version ubuntu
SQL