/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

1 vote274 views1 answer
Oracle split string
SQL
1 vote267 views1 answer
Can not connect to mysql server
SQL
1 vote284 views1 answer
Woocommerce mysql price table
SQL
0 vote242 views2 answers
Influxdb delete measurement based on date
SQL
1 vote314 views2 answers
Full join
SQL
-1 vote340 views5 answers
Left join sql
SQL
6 votes306 views3 answers
Rename column ORACLE
SQL
0 vote260 views1 answer
Database springboot
SQL
0 vote328 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
-1 vote292 views5 answers
Convert sql to linq query online
SQL