Skip to content

Instantly share code, notes, and snippets.

@adityadeshpande

adityadeshpande/TruncateAllTables.sql Secret

Created November 2, 2020 17:51
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 adityadeshpande/e797fd5cc3e5d0610a4afbf89da23c7f to your computer and use it in GitHub Desktop.
Save adityadeshpande/e797fd5cc3e5d0610a4afbf89da23c7f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
TruncateAllTables.sql
DECLARE @SqlCmd NVARCHAR(MAX)
SELECT @SqlCmd = COALESCE(@SqlCmd + CHAR(10), '') + N'TRUNCATE TABLE ' + QUOTENAME(s.name) + '.' + QUOTENAME(t.name) + ';'
FROM sys.tables t
INNER JOIN sys.schemas s ON s.schema_id = t.schema_id
WHERE t.[name] <> 'sysdiagrams'
AND t.is_ms_shipped = 0
PRINT @SqlCmd
EXEC sp_executesql @SqlCmd
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment