Everything related to SQL and databases.
2 posts • Page 1 of 1
I 'd like to clear the database altogether and reset the data. Exactly what's the quickest method to do that? Or, what's the command that will erase all the rows of a table (and I'll duplicate that process for all tables)? Thanks
If you don't want to script and drop the tables, there are a variety of methods to do this with a loop. Here's most likely the easiest: sp_MsForEachTable 'TRUNCATE TABLE?'