# Best way to DROP Table? **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [February 16, 2012, 9:58am UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035 "2012-02-16T09:58:07Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![steve.boothweenergie](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@steve.boothweenergie](https://forums.toadworld.com/u/steve.boothweenergie)\ **Post date:** [February 16, 2012, 9:58am UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/1 "2012-02-16T09:58:07Z")
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? Thanks, Steve…. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [February 16, 2012, 10:03am UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/2 "2012-02-16T10:03:08Z")
Just drop it. Find it in the SB LHS and hit the delete key. Check both options. I don’t think it’s any faster to truncate it first, if that is what you are asking. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 16, 2012, 10:09am UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/3 "2012-02-16T10:09:14Z")
That should still leave it in the recycle bin for a while. So if you really want it gone, purge the recycle bin, too. Schema Browser, as usual. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [February 16, 2012, 10:11am UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/4 "2012-02-16T10:11:25Z")
There’s a purge option on that ‘drop table’ dialog that bypasses the recycle bin. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 16, 2012, 10:14am UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/5 "2012-02-16T10:14:40Z")
Thanks. For some reason, I’d never noticed that. Just blind, I guess. Or maybe I’ve just been trained to never really delete anything if you don’t have to. – jim ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [February 16, 2012, 10:21am UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/6 "2012-02-16T10:21:47Z")
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] ---
**Author:** ![michaeljmooregmail.c](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michaeljmooregmail.c/32/12432_2.png) [@michaeljmooregmail.c](https://forums.toadworld.com/u/michaeljmooregmail.c)\ **Post date:** [February 16, 2012, 12:10pm UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/7 "2012-02-16T12:10:50Z")
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 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] ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 16, 2012, 12:33pm UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/8 "2012-02-16T12:33:17Z")
That could get you in trouble for littering. Anyone remember Alice’s Restaurant? Nate Schroeder Enterprise Services - Data Management Team Monsanto Company 800 N. Lindbergh Blvd. B2SB - Saint Louis, MO - 63167 314-694-2592 ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 16, 2012, 1:28pm UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/9 "2012-02-16T13:28:43Z")
I barely remember that, but yup… a fat chubby abusive cook/owner with Alice usually getting the better of him. ---
**Author:** ![dbmadvig\_734](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@dbmadvig\_734](https://forums.toadworld.com/u/dbmadvig_734)\ **Post date:** [February 16, 2012, 1:34pm UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/10 "2012-02-16T13:34:35Z")
“That’s not the name of the restaurant; that’s the name of the song. That’s why I call it, ‘Alice’s Restaurant’.” J Daniel B Madvig Campus Technologies Northwestern College & Northwestern Media 3003 Snelling Ave. St. Paul, MN 55113 www.nwc.edu 651.631.5323 ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/e/effaa23be67883dfddff29c942e94f63f30c3158.jpeg) ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [February 16, 2012, 1:35pm UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/11 "2012-02-16T13:35:22Z")
Since no one else said it – I miss Flo and her saying “Kiss my grits!” J ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [February 16, 2012, 2:04pm UTC](https://forums.toadworld.com/t/best-way-to-drop-table/11035/12 "2012-02-16T14:04:01Z")
That’s a great song. I love the part about looking for a place to put the garbage – with the dump being closed on Thanksgiving. “There, at the bottom of the cliff, we saw another pile of garbage! We figured one big pile is better than two little piles, and rather than bring that one up, we decided to throw ours down.” I grew up in San Antonio, TX, and the radio station there would play that 20 minute long song once a year, on Thanksgiving. ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/e/effaa23be67883dfddff29c942e94f63f30c3158.jpeg)