"Jan Doggen" <j.******@BLOCKqsa.nl> wrote in news:43a2ee48$0$11062
$e*******@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.