Posted by Joe Hurzeler on 10/25/07 01:02

Hugo Kornelis <hugo@perFact.REMOVETHIS.info.INVALID> wrote in
news:p36ia39c3bhvcs5dfjsbluvphgus0nbqtu@4ax.com:

> On Thu, 26 Jul 2007 12:01:36 -0700, Tmuld wrote:
>
>>Is there a way to delete all data from a database - all tables and all
>>tables excluding system tables?
>>
>>sqlserver 2000?
>
> Hi Tmuld,
>
> DROP DATABASE xxx
> go
> CREATE DATABASE xxx
> -- add options here
> go
>

Might not be a bad idea to create a script to recreate the database and all
its objects before you start if you don't want to reinvent the wheel.

[Back to original message]