Re: Remove all tables for user with one SQl statement?

From: Chuck <skilover_nospam_at_softhome.net>
Date: Mon, 09 Jan 2006 15:59:32 GMT
Message-ID: <Xns97466FD2C832skiloversofthomenet@127.0.0.1>

"Jan Doggen" <j.doggen_at_BLOCKqsa.nl> wrote in news:43a2ee48$0$11062 $e4fe514c_at_news.xs4all.nl:

> Hi
>
> How can I remove all tables
> UserName.TblNam1
> UserName.TblNam2
> UserName.TblNam3
> etc
>
> with one SQL statement?
>
> Thanks in advance
> Jan
>
>

An anonymous PL/SQL block...

begin

executute immediate 'drop table UserName.TblNam1';
executute immediate 'drop table UserName.TblNam2';
executute immediate 'drop table UserName.TblNam3';

end;
/

Or you could write a "dropalltables" stored procedure and run that. Received on Mon Jan 09 2006 - 09:59:32 CST