Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I drop schema objects?
Be careful with this - you can do serious damage!
DROP USER USER_NAME CASCADE; Obviously you want to replace USER_NAME with the name of the user/schema that you want to get rid of.
Darin Pendergraft
Quest Software
Gennady <gennadyb_at_halcosoftware.com> wrote in message
news: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:34:21 CDT
![]() |
![]() |