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.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 How to clear the whole databse?

Author  Topic 

moramoga
Starting Member

34 Posts

Posted - 2007-04-07 : 15:43:06
Hi, my database i am working on is full of crab, who do I clear all the tables info?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-07 : 16:51:48
See this post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72957
Run it and then truncate all tables with the highest number first.
Then the second highest and so on...


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-04-07 : 18:40:15
or:

1. script out all objects
2. drop the database
3. recreate from scripts


www.elsasoft.org
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-04-08 : 02:41:11
See also:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79596
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37683
Go to Top of Page
   

- Advertisement -