Re: Best way to DROP Table?

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

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/