Re: How can I drop schema objects?

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Thu, 3 Jun 1999 12:49:10 -0600
Message-ID: <3756cded.0@news.cadvision.com>

Either drop the user or use:

spool x.sql
select 'drop ' || object_type || ' ' || owner || '.' || object_name || ';' from all_objects
where owner = 'xxxx'
and object_type in ('TABLE','VIEW','PROCEDURE' , whatever else ); spool off
@x.sql

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Gennady wrote in message <3756b7d0$0$3120_at_fountain.mindlink.net>...
>Hello,
>How can I drop all schema objects which belongs
>to particular user using SQL statements?
>
>Gennady
>
>
Received on Thu Jun 03 1999 - 13:49:10 CDT