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

On 19.12.2005 10:21 sybrandb_at_yahoo.com wrote:
> You can't.
> You can of course
> begin
> for tab in (select table_name from dba_tables where owner= 'UserName' )
> loop
> execute immediate 'drop table Username.'||tab.table_name||' cascade
> constraints';
> end loop;
> end;
> /
> But you would need to make sure there are no foreign keys or drop the
> tables in the right order.

Hmm, this confuses me a bit.

A "DROP TABLE xyz CASCADE CONSTRAINTS" will remove all constraints on the table as well, including foreign keys.

So the order shouldn't actually matter in that case, shouldn't it?

Thomas

-- 
It's not a RootKit - it's a Sony