Re: How to delete a database?

Ku Kam Ming wrote:
>
> as title! No drop database statment!!
>
> Thanks,
> --

It really depends on what you mean.

If you are trying to delete an instance and all of it's associated files you have to trawl through your filesystem removing all the files related to it, and then edit any files that may refer to it.

If you want to remove a schema from an instance then you can drop the owning user and cascade through it's objects.

Glenn. Received on Fri Nov 29 1996 - 00:00:00 CST