code to remove the default tables in Oracle 11g

 

drop table apex$_acl cascade constraint;
drop table apex$_ws_files cascade constraint;
drop table apex$_ws_history cascade constraint;
drop table apex$_ws_links cascade constraint;
drop table apex$_ws_notes cascade constraint;
drop table apex$_ws_rows cascade constraint;
drop table apex$_ws_tags cascade constraint;
drop table apex$_ws_webpg_section_history cascade constraint;
drop table apex$_ws_webpg_sections cascade constraint;
drop table apex$_ws_sections cascade constraint;
drop table demo_customers cascade constraint;
drop table demo_order_items cascade constraint;
drop table demo_orders cascade constraint;
drop table demo_product_info cascade constraint;
drop table demo_states cascade constraint;
drop table demo_users cascade constraint;
drop table dept cascade constraint;
drop table emp cascade constraint;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s