Is there a quick way that I can empty an entire databas...

[SpecOPS]

{topic}

[Terra]

drop database xacme_2;
then
create database xacme_2;

(replace xacme_2 with your database name)

This will wipe out every table in the db...

--
Terra
--The thrill of pushing the big red shiny button--
FutureQuest

<EDIT: clarify to avoid literal interpretation>

[This message has been edited by ccTech (edited 04-28-01@6:49 pm)]

[jimbo]

<EDIT: clarify to avoid literal interpretation> http://forums.bronx-bombers.com/images/smilies/erm-ah.gif

-jim

[Terra]

you would be surprised...

Just consider it over 3 years of providing technical support for FutureQuest...

Figured someone would get a kick out of that line...[nbsp][nbsp]:)

--
Terra
--ERROR 1008: Can't drop database 'xacme_2'. Database doesn't exist--
FutureQuest