/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 vote188 views1 answer
How to search query in python3 sqlite3
SQL
0 vote177 views1 answer
Database get 10 user aleatory
SQL
0 vote187 views1 answer
Greater than or equal to symbol in postgres
SQL
16 votes174 views3 answers
Delete row psql
SQL
0 vote194 views1 answer
Calculate age in sql
SQL
1 vote177 views1 answer
Median mysql
SQL
0 vote175 views1 answer
Composit key in sql
SQL
1 vote174 views3 answers
Mariadb add foreign key
SQL
2 votes182 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote184 views1 answer
Sql server datetime
SQL