Re: Deleting a schema in Oracle 9i

John wrote:

> Hi All,
>
> Can anyone tell me how to delete a schema (and all of its related tables
> and views) in a step or two?
>
> Thanks

drop user FRED cascade;

(A command which comes about because in Oracle a schema is simply a collection of objects owned by a user. So if you drop the user, you inevitably drop the schema).

Regards
HJR Received on Thu Oct 07 2004 - 22:43:54 CDT