subash

• Apr 22nd, 2007

 

No, because we can drop only one table or table data by using drop.

abhishek reddy

• May 6th, 2007

 

Yes we can drop more than 1 table  using  spool.


Dropping all tables from a user:----

sql> select 'drop table' || 'tname' || from tab;

sql> spool pp;

//copy all the data  from all the tables//

sql>spool off;

sql> @pp.lst

senthilora

• Sep 24th, 2007

 

That is not correct Abhishek reddy..:)

Spool is not a SQL statement.  Moreover, actually you are creating multiple SQL statements and executing them.

No - would be my answer if the question was "is that possible to drop more than one table by using single DROP TABLE statement"

Yes - is my answer as "DROP USER .. CASCADE" statement will drop all the tables at once owned by a specific user. 

abdulraheem_ar

 Profile Answers by abdulraheem_ar 

• Aug 5th, 2008

 

Try using substitution variable like

DROP TABLE &table_name

skranof

 Profile Answers by skranof 

• Jul 2nd, 2009

 

I assume you already figured this out, but if not

simply

use dbName
go

drop table table1, table2, table3