/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 votes251 views1 answer
Set boolean flasksql
SQL
0 vote246 views1 answer
How to create an SQL save method in ruby
SQL
0 vote273 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote246 views1 answer
Sql row number in result set
SQL
0 vote244 views1 answer
Insert thai language sql server
SQL
0 vote262 views1 answer
Varchar2 length in oracle
SQL
0 vote253 views1 answer
Except in sql
SQL
6 votes288 views6 answers
Rename column postgres
SQL
0 vote270 views1 answer
SQL column name Oracle
SQL
0 vote258 views1 answer
Copy data from cell to cell mysql
SQL