/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 vote265 views1 answer
Oracle index partition
SQL
0 vote292 views1 answer
How to check database engine in mysql
SQL
0 vote301 views1 answer
Mysql bash execute sql file
SQL
0 vote272 views1 answer
Sql server datetime to string
SQL
4 votes259 views3 answers
Create database in mySQL
SQL
11 votes284 views1 answer
Oracle insert into where
SQL
1 vote268 views1 answer
Oracle activate job
SQL
5 votes283 views2 answers
Postgresql insert select
SQL
0 vote277 views1 answer
How to change null display in psql
SQL
0 vote221 views1 answer
Sqlalchemy filter relationship
SQL