rem
rem $Id: dropall.sql,v 1.1 1998/11/03 02:46:32 yxia Exp $
rem

rem  +------------------------------------------------------------------+
rem  |  DROPALL.SQL -- DROP MODULES FROM SQL*PLUS                       |
rem  |                                                                  |
rem  |  This script is used to drop all modules from the DB without     |
rem  |  having to use the SQLREP interface.  It is a SQL*Plus script,   |
rem  |  and will not run under SQL*DBA.                                 |
rem  |                                                                  |
rem  +------------------------------------------------------------------+

set verify off;
set feedback off;

delete from srw2_anchor where owner=user;
commit;

delete from srw2_boilerplate where owner=user;
commit;

delete from srw2_text_segment where owner=user;
commit;

delete from srw2_button where owner=user;
commit;

delete from srw2_column where owner=user;
commit;

delete from srw2_data_model where owner=user;
commit;

delete from srw2_field where owner=user;
commit;

delete from srw2_frame where owner=user;
commit;

delete from srw2_group where owner=user;
commit;

delete from srw2_link where owner=user;
commit;

delete from srw2_layout where owner=user;
commit;

delete from srw2_body_location where owner=user;
commit;

delete from srw2_layout_group where owner=user;
commit;

delete from srw2_matrix where owner=user;
commit;

delete from srw2_og_document where owner=user;
commit;

delete from srw2_ogd_column_map where owner=user;
commit;

delete from srw2_param_form where owner=user;
commit;

delete from srw2_query where owner=user;
commit;

delete from srw2_element where owner=user;
commit;

delete from srw2_display_tag where owner=user;
commit;

delete from tool_access where owner=user;
commit;

delete from tool_library where owner=user;
commit;

delete from tool_ltext where owner=user;
commit;

delete from tool_lraw where owner=user;
commit;

delete from tool_plsql where owner=user;
commit;

delete from tool_comment where owner=user;
commit;

delete from tool_depend where owner=user;
commit;

delete from ROSSTRINGS where owner=user;
commit;

delete from vg_color where owner=user;
commit;

delete from tool_module where owner=user;

set feedback on;
set verify on;

exit;
