Posted by Hugo Kornelis on 07/26/07 21:56

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

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

[Back to original message]