Truncate all tables in a SQL Server database This is an off-site link.  Please review our Terms of Service for additional information.

(Dave Bennett) As a DBA I have found many occasions in testing of various SQL Server deployments and scripts where I need to load a database with data from a lower environment or where I need to alter a table that might already have data in it in such a way that I need to first eliminate the data before I can proceed. Depending on the foreign key constraints in place, clearing old data can be a tedious process.

Read this article...

comments powered by Disqus