Quick Script to Delete all Table records in MS SQL Server DB

[Softex]

Since our line of business involves administration of literally hundreds of Microsoft SQL Server Databases, We had always have the need for a quick script to clean some database tables from all records without the need of writing custom script with "delete * from each table name" , we just needed a script that loops on all tables, just delete all records and then reset the identity columns.

Out technical team have found such script and we would love to share it with the world

this works with SQL Server 2008 Databases or later, and if any table in the database does not have identity column inside it, the script will raise the error but the records will be deleted anyway, so do not worry about it.

It is very important to backup your database before using such scripts because there is no going back once you run it

Script below in the attached file

DeleteAll Records Script - MS SQL 2008 R2.docx

(19.27 KiB) Downloaded 1124 times

Enjoy