Droping Tables In Oracle - Programming - Nairaland
Nairaland Forum / Science/Technology / Programming / Droping Tables In Oracle (856 Views)
How Do I Search Multiple Tables In A Database For A Query? / Sql For Joing 3 Tables In My Databse / Why Relationship Between Tables In A Database (2) (3) (4)
(1) (Reply)
| Droping Tables In Oracle by rafiusalis: 7:02am On Aug 07, 2008 |
Hi Guys, please I want to know how to drop series of tables in oracle instead of using DROP TABLE <tablename>; |
| Re: Droping Tables In Oracle by LeMoor(m): 7:12pm On Aug 07, 2008 |
Use the TRUNCATE command. Remember if it has any referential intergrity, then you have to use the 'CASCADE' option. |
(1) (Reply)
Need Java Tips! / Are You An Advanced Software Developer? Pls Lets Talk Business / I Need A Code From You Help
(Go Up)
| Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 5 |