MS SQL Server Alter Table Drop Foreign Key
The RazorSQL alter table tool includes a Drop Foreign Key option for dropping a foreign key from a MS SQL Server database table. The drop foreign key function generates the appropriate alter table drop foreign 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 Foreign Key function:
ALTER TABLE test.dbo.Employee DROP CONSTRAINT FK__Employee__dno__182C9B23;
Below is a screen shot of the drop foreign key function of the MS SQL Server alter table tool.