Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
k1t3
Starting Member
5 Posts |
 Posted - 2010-01-22 : 00:01:51
|
| Is there a way to clean all tables or objects within a database andmake it like a brand new database? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-22 : 01:50:30
|
| TRUNCATE TABLE on each table. If the table has a FOREIGN KEY you'll need to use DELETE TABLE instead (which is slower)Or script the whole database and run that script against a brand new, empty, database.But IME most databases need some data at the get-go - config stuff and the like. |
 |
|
|
|
|
|
Clean or Refresh Database?