/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

25 votes356 views5 answers
Uninstall mysql ubuntu
SQL
0 vote422 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote339 views1 answer
Mysql command prompt date insert format
SQL
3 votes379 views1 answer
Sql insert inserted id
SQL
0 vote360 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote387 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote358 views1 answer
Select from column mysql
SQL
18 votes355 views6 answers
Create table mysql
SQL
0 vote347 views1 answer
Get first monday of month sql
SQL
25 votes366 views4 answers
Metadata
SQL