Skip to content

Instantly share code, notes, and snippets.

@kstenson

kstenson/delete.sql

Created September 3, 2012 15:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kstenson/3609998 to your computer and use it in GitHub Desktop.
Save kstenson/3609998 to your computer and use it in GitHub Desktop.
Download ZIP
clear all tables in db
Raw
delete.sql
-- disable all constraints
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
-- delete data in all tables
EXEC sp_MSForEachTable "DELETE FROM ?"
-- enable all constraints
exec sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment