MS SQL Server Alter Table Drop Primary Key
The RazorSQL alter table tool includes a Drop Primary Key option for dropping a primary key from a MS SQL Server database table. The drop primary key function generates the appropriate alter table drop primary key SQL command for dropping the key from the table.
Listed below is an example of the SQL generated by the MS SQL Server Alter Table Drop Primary Key function:
ALTER TABLE test.dbo.Employee
DROP CONSTRAINT PK__Employee__15502E78
Below is a screen shot of the drop primary key function of the MS SQL Server alter table tool.
