SQL Server deletes a table's foreign key constraint

Many tables in SQL Server have foreign key constraints. before deleting these tables, you must first Delete these foreign key constraints.

The stored procedure used to delete the foreign key constraints of a table:

1. Create procedure sp_drop_all_fk
2. As
3. Declare @ SQL varchar (255)
4. Declare dropsql_cursor cursor
5. Select 'alter table' + object_name (fkeyid) + 'drop constraint' + object_name (constid) + char (10) from sysreferences
7. Open dropsql_cursor
9. Fetch dropsql_cursor into @ SQL
11. Begin tran
13. While @ fetch_status = 0
14. Begin
16. Execute (@ SQL)
18. If @ error <> 0
19. Begin
20. Rollback
21. Return
22. End
24. Fetch dropsql_cursor into @ SQL
26. End
27. Deallocate dropsql_cursor
29. Commit
30. Go
32. Exec sp_drop_all_fk -- executes the Stored Procedure