/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 vote117 views1 answer
Replace multiple string in query sql
SQL
2 votes76 views1 answer
Oracle sql drop column if exists
SQL
0 vote141 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
19 votes110 views6 answers
Sql drop table if exists
SQL
0 vote112 views1 answer
Mysql xampp reset root password
SQL
0 vote114 views1 answer
Oracle sql date winter time
SQL
0 vote125 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote133 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote104 views1 answer
Postgresql regular expression special characters
SQL
0 vote115 views1 answer
Sql count null values in all columns
SQL