/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

2 votes341 views1 answer
Sql string_agg
SQL
0 vote349 views1 answer
Mysql 3 months ago
SQL
1 vote332 views1 answer
Sql server kill all connections
SQL
0 vote334 views1 answer
Sql server list table sizes
SQL
3 votes360 views1 answer
How to add unique constraint in mysql table
SQL
0 vote330 views1 answer
Alter table engine mysql
SQL
16 votes344 views2 answers
Mysql date between two dates
SQL
0 vote279 views1 answer
Expose db in virtualbox
SQL
1 vote323 views2 answers
Sql example query
SQL
0 vote310 views1 answer
Sql database size
SQL