/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

0 vote136 views2 answers
Auto increment column in mysql query results
SQL
2 votes135 views1 answer
Oracle apex list connected users
SQL
7 votes135 views1 answer
Safe update mysql
SQL
0 vote157 views1 answer
Repeatable read trong sql server
SQL
2 votes136 views1 answer
Check isolation level in mysql
SQL
0 vote151 views1 answer
Insert or update sql firebird
SQL
0 vote133 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote145 views1 answer
Oracle cpu metric
SQL
0 vote97 views1 answer
Mysql find foreign key references
SQL
0 vote127 views1 answer
Call scalar valued function sql
SQL