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
2,567 reads
By Steve Jones
Learn how to take a 20-minute power nap without embarassment. – from Excellent Advice...
Yes, SSMS 21 uses the Visual Studio installer. No, you don’t need to download...
Comments posted to this topic are about the item The Next Great Thing
Comments posted to this topic are about the item Building a Database Dashboard with...
Comments posted to this topic are about the item Enabling Change Tracking
If I want to set up Change Tracking in a database, what should I do first in SQL Server 2022?
See possible answers