T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.
2019-12-10
1,916 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I’ve added a new parameter to my permissions scripts (well, just the main two...
By Steve Jones
UPDATE: Article changed based on the comment from Mr. Sewell. I wrote recently about...
Comments posted to this topic are about the item How to use PowerShell to...
Comments posted to this topic are about the item INSERT EXEC statement cannot be...
Comments posted to this topic are about the item Cleaning Tables
Ask SSC