/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 vote266 views1 answer
Ora-01950 no privileges on tablespace
SQL
79 votes589 views6 answers
Grepper code
SQL
0 vote257 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
7 votes208 views2 answers
Add column table pl sql
SQL
1 vote261 views1 answer
Show per page table in xampp
SQL
10 votes242 views4 answers
Join multiple tables in sql
SQL
0 vote210 views1 answer
Sql get guid
SQL
0 vote193 views2 answers
Postgresql display subquery as json
SQL
1 vote197 views4 answers
Postgres extract date from timestamp
SQL
0 vote202 views1 answer
To change the database owner in SQL server
SQL