GitHub - philbo/DBCleaner: Collection of scripts to clear out data from any populated tables in a SQL Server DB

philbo / DBCleaner Public

Notifications You must be signed in to change notification settings
Fork 0
Star 1

Collection of scripts to clear out data from any populated tables in a SQL Server DB

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
DropAndRecreateForeignKeys.sql		DropAndRecreateForeignKeys.sql
GetTablesWithData.sql		GetTablesWithData.sql
README		README

Repository files navigation

Using the two scripts you can clear out any data from an exisiting SQL Server database.

1. Run 'DropAndRecreateForeignKeys.sql' to generate statements to drop and recreate all foreign keys.
2. Run 'GetTablesWithData.sql' to generate statements to delete data from existing tables.
3. Run the drop foreign key statements.
4. Run the delete statements.
5. Run the recreate foreign key statements.