/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 vote304 views2 answers
Postgresql remote connect
SQL
0 vote303 views1 answer
Mysql multiple primary keys
SQL
23 votes301 views1 answer
How remove column in mysql
SQL
0 vote304 views1 answer
Sql where part of string match
SQL
1 vote334 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote336 views1 answer
New rails app with mysql
SQL
0 vote320 views1 answer
Postgres can integer fields be negative
SQL
0 vote297 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote296 views1 answer
Populate db from command line postgres
SQL
0 vote356 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL