Hi

How can I remove all tables
UserName.TblNam1
UserName.TblNam2
UserName.TblNam3
etc

with one SQL statement?

Thanks in advance
Jan

1) Newsgroup is obsolete - please use comp.databases.oracle.server'

2) Is dropping the user at the same time allowed?

"Jan Doggen" <j.doggen (AT) BLOCKqsa (DOT) nl> wrote in news:43a2ee48$0$11062
$e4fe514c (AT) news (DOT) xs4all.nl:


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.