/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 vote343 views3 answers
Sql query checker
SQL
0 vote300 views1 answer
Oracle list all stored procedures
SQL
10 votes327 views1 answer
Oracle all_dependencies
SQL
0 vote331 views1 answer
How to drop a trigger in postgresql
SQL
0 vote337 views2 answers
Jsonb
SQL
8 votes354 views4 answers
Reset SQL auto increment
SQL
1 vote344 views1 answer
Oracle previous year
SQL
0 vote336 views1 answer
Mariadb errno 121
SQL
1 vote329 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
13 votes528 views4 answers
Sql joining 3 tables
SQL