sql server - SQL DROP TABLE foreign key constraint - Stack Overflow

In SQL Server Management Studio 2008 (R2) and newer, you can Right Click on the DB -> Tasks -> Generate Scripts. Select the tables you want to DROP. Select "Save to new query window". Click on the Advanced button. Set Script DROP and CREATE to Script ...

stackoverflow.com