/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 vote164 views1 answer
Difference between varchar and varchar2
SQL
0 vote161 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote179 views1 answer
Sum sqlserver
SQL
0 vote201 views4 answers
Best data type to represent money in mysql
SQL
0 vote171 views1 answer
Postpresql relation not found
SQL
0 vote159 views1 answer
Restore backup "text" postgresql command line
SQL
5 votes159 views4 answers
Describe table postgres
SQL
0 vote155 views2 answers
Mysql slave status
SQL
0 vote211 views1 answer
Tsql cte in a transaction
SQL
38 votes234 views6 answers
Alter table mysql
SQL