/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

5 votes368 views1 answer
Mysql where one year ago
SQL
0 vote327 views1 answer
Count number of entires by months sql
SQL
0 vote308 views1 answer
Add SuperUser MySQL
SQL
0 vote328 views1 answer
What does leave do in mysql
SQL
37 votes311 views3 answers
Postgresql insert column
SQL
0 vote335 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
1 vote308 views1 answer
Mysql limit results to 10
SQL
0 vote370 views1 answer
Mysql concatenate select results
SQL
0 vote402 views1 answer
How to show current database in mysql
SQL
0 vote304 views1 answer
SQL isnumeric DB2
SQL