/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 vote232 views1 answer
Sql server beginning of month
SQL
0 vote192 views1 answer
How to export only procedures mysql
SQL
0 vote183 views1 answer
How to execute stored output to csv files
SQL
1 vote208 views1 answer
Mysql count all table rows
SQL
0 vote184 views1 answer
Change data type in mysql
SQL
0 vote202 views1 answer
Comparing with today and yesterday record in sql query
SQL
8 votes206 views1 answer
Mysql limit rows
SQL
3 votes218 views1 answer
DB: in eloquent using sql
SQL
1 vote294 views1 answer
Mysql is odd
SQL
0 vote193 views1 answer
Soql more than today
SQL