Re: Best way to DROP Table?

Take it to a very secluded canyon and drop it off a cliff. So says the
Oracle.


On Thu, Feb 16, 2012 at 8:21 AM, Norman Dunbar <[email protected]> wrote:

> Hi Steve,
>
> On 16/02/12 15:58, Booth.Steve wrote:
> > Quick Oracle Question: If I have a huge table and I want it to be gone,
> > destroyed, zilch nada.
> >
> > What’s the fastest way to get rid of it?
>
>
> Pre Oracle 10G:
> drop table WHATEVER cascade constraints;
>
>
> 10g onwards:
> drop table WHATEVER cascade constraints purge;
>
>
> --
> Cheers,
> Norm. [TeamT]
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>