Delete SQL table records based on foreign key dependencies
Just a heads up on a really useful blog post: Script to Delete Data from SQL Server Tables with Foreign Key Constraints
Basically it creates a stored procedure to display the dependencies based on a table name and a condition, then some other code to generate hierarchical delete code.
Basically it creates a stored procedure to display the dependencies based on a table name and a condition, then some other code to generate hierarchical delete code.
Comments
Be the first to post a comment