Droping Tables In Oracle

Date: December 02, 2008, 11:25 AM
267202 members and 164169 Topics
Latest Member: osoisi

Nairaland Forum | Technology | Programming (Moderator: Dual Core) | Droping Tables In Oracle

Pages: (1)

Author

Topic: Droping Tables In Oracle (Read 100 views)

rafiusalis

Droping Tables In Oracle

« on: August 07, 2008, 07:02 AM »

Hi Guys, please I want to know how to drop series of tables in oracle instead of using DROP TABLE <tablename>;

Le Moor (m)

Re: Droping Tables In Oracle

« #1 on: August 07, 2008, 07:12 PM »

Use the TRUNCATE command.
Remember if it has any referential intergrity, then you have to use the 'CASCADE' option.

Pages: (1)