MS SQL Server Alter Table Drop Constraint

The RazorSQL alter table tool includes a Drop Constraint option for dropping a constraint from a MS SQL Server database table. The drop constraint function allows the user to enter a constraint to drop from the table. The tool then generates the appropriate alter table drop constraint SQL command for dropping the constraint from the table.

Listed below is an example of the SQL generated by the MS SQL Server Alter Table Drop Constraint function:

ALTER TABLE test.dbo.Employee DROP CONSTRAINT test_const

Below is a screen shot of the drop constraint function of the MS SQL Server alter table tool.

MS SQL Server Drop Constraint