I wish to delete all the tables that I have made so far........What should I do ????
Please help !!!
apanimesh061 0 Junior Poster
debasisdas 580 Posting Genius Featured Poster
You need to drop all the tables.
Drop child table first and then the parent table.
apanimesh061 0 Junior Poster
Sir, basically I wish to delete all tables at once. I wish to clear the existing database. I has got 44 tables.
I want to know a way by which I can delete all tables, existing functions, triggers, or procedures.
debasisdas 580 Posting Genius Featured Poster
why not drop the schema then .
apanimesh061 0 Junior Poster
Hmmmm.....Sir , I was wondering if I delete the existing database..Will that hinder further operations in Oracle..?????
debasisdas 580 Posting Genius Featured Poster
No need to drop entire database , you simply need to drop the desired tables.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.