sql to create sql 1

[scohan]

I've done this before but can't remember the syntax nor find a saved script. I want to run a sql statement to create a 'drop table ...' for every table in a schema, but I can't remember the sytax surrounding the table_name column in the select statement. I have something like:

select "drop table " table_name " cascade contraints;" from user_tables;

but it's not working.

????

Thanks.

 

[ManjulaMadhu]

try :

select 'drop table '||table_name||' cascade contraints;' from user_tables;

 

[scohan]

ah, but of course. thanks much.