|
|
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
Navigation:
[Reply to this message]
|