/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 vote143 views1 answer
Databricks install odbc driver connect to sql server
SQL
2 votes146 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
31 votes169 views4 answers
Mysql grant execute
SQL
0 vote139 views1 answer
Select the date 30 days less that the todays date sql request
SQL
9 votes127 views2 answers
Get first 3 letters in sql
SQL
0 vote96 views1 answer
Oracle function select into
SQL
0 vote129 views1 answer
Sql server split string and insert into table select
SQL
0 vote130 views1 answer
Case when with count and combining similar values in sql
SQL
1 vote147 views1 answer
SQL Integer devision
SQL
0 vote135 views1 answer
Psql attribute cannot login
SQL