rem
rem  $Header: /net/tools-build/build12/ros991/spam/precious/files/ACTIVE/tooldrop.sql,v 1.1 1998/01/07 02:02:11 yxia Exp $
rem
rem  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
rem
rem  tooldrop.sql
rem
rem  This script drops the shared module storage tables from the account
rem  in which they reside (usually SYSTEM).
rem

drop table tool__access;
drop view tool_access;
drop view tool_accessible;
drop public synonym tool_access;
drop public synonym tool_accessible;

drop table tool__library;
drop view tool_library;
drop public synonym tool_library;

drop sequence tool_modid;
drop public synonym tool_modid;

drop table tool__module;
drop view tool_module;
drop public synonym tool_module;

drop table tool__ltext;
drop view tool_ltext;
drop public synonym tool_ltext;
drop sequence tool_ltext_id;
drop public synonym tool_ltext_id;

drop table tool__lraw;
drop view tool_lraw;
drop public synonym tool_lraw;
drop sequence tool_lraw_id;
drop public synonym tool_lraw_id;

drop table tool__plsql;
drop view tool_plsql;
drop public synonym tool_plsql;

drop table tool__comment;
drop view tool_comment;
drop public synonym tool_comment;

drop table tool__depend;
drop view tool_depend;
drop view tool_dependent;
drop public synonym tool_depend;
drop public synonym tool_dependent;