/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 vote110 views1 answer
Sql select rows with simlar names
SQL
0 vote142 views1 answer
Tsql delete all rows
SQL
15 votes144 views4 answers
How to get all tables in sql
SQL
0 vote146 views1 answer
Oracle remove line breaks
SQL
15 votes333 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote176 views1 answer
Mysql config slave
SQL
2 votes144 views6 answers
In in sql
SQL
0 vote142 views1 answer
Access refused mysql xampp server
SQL
22 votes182 views4 answers
Date format mysql
SQL
1 vote141 views1 answer
Drop df constraint sql server
SQL