Skip to content

Instantly share code, notes, and snippets.

@marcelodeandrade

marcelodeandrade/truncate_table_with_fks.sql

Last active September 3, 2018 17:35
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 marcelodeandrade/93aad19c9d6bedc2feee7fcb2a011d48 to your computer and use it in GitHub Desktop.
Save marcelodeandrade/93aad19c9d6bedc2feee7fcb2a011d48 to your computer and use it in GitHub Desktop.
Download ZIP
Truncate table with FK's
Raw
truncate_table_with_fks.sql
DELETE FROM database.dbo.table
DBCC CHECKIDENT ('database.dbo.table', RESEED, 0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment