/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 vote160 views1 answer
Access refused mysql xampp server
SQL
19 votes141 views1 answer
Sqrt(-1)
SQL
0 vote168 views1 answer
Postgress append string in select
SQL
25 votes174 views6 answers
Sql update query
SQL
1 vote182 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote198 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote177 views1 answer
Rename view mysql
SQL
0 vote170 views1 answer
Denormalise SQL command
SQL
1 vote168 views1 answer
Mysql connect command
SQL
0 vote189 views1 answer
Sqlite explain plan
SQL