Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Drop table

715920Aug 23 2009 — edited Aug 25 2009
Dear coders,
questions from a newbie on how to drop tables:

1. How can I drop a table in cascade manner so that it's dropping its constraints?
I did:

drop table [table name] cascade

but it complains that it missing a keyword.

2. What is the easiest command to drop all table without deleting a schema?
3. Is it possible to delete a schema through sql command line in XE?

regards,
Valerie

Edited by: Valerie Debonair on Aug 23, 2009 8:26 PM
This post has been answered by 698358 on Aug 24 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2009
Added on Aug 23 2009
7 comments
809 views