sql server remove primary key without dropping table

Solutions on MaxInterview for sql server remove primary key without dropping table by the best coders in the world

Search
showing results for - "sql server remove primary key without dropping table"
Carl
21 Feb 2019
1IF EXISTS (SELECT * FROM sys.key_constraints
2           WHERE type = 'PK' AND parent_object_id = OBJECT_ID('MyTable')
3           AND Name = 'PK_MyTable')
4    ALTER TABLE MyTable DROP CONSTRAINT PK_MyTable
5
source
similar questions
drop primary keydrop df constraint sql serverdelete double on sql with multiple primary keyssql drop primary keyhow to remove foreign key constraint in sqldrop check constraint in ms sqldropping a constraint in ms sqldrop constraint in ms sqldrop unique key constraint in sql serverdrop primary key oracleremove unique key from a tablemssql disable foreign key constraintdrop foreign keysql server drop table if existsuncheck constraints and delete from tableremove primary key from tabledrop table with constraintsdrop column if exists sql serverhow to drop columns with constraint from a table in sql scripthow to remove identity from a column in sql serverremove primary key from a tabletable drop if exist sql server
queries leading to this page
sql server make field primary key without dropping tablehow to delete records in table with no primary keysql server remove primary key without dropping table