set termout off
set echo off
/* Copyright (c) 1991, 1994 by Oracle Corporation.  All Rights Reserved */
/*
$Id: brwdrs60.sql,v 1.1 1998/01/08 01:05:41 yxia Exp $
*/
/***
  Drop Oracle Query Builder System Tables

***/
REM   MODIFIED
Rem     dyee       09/11/97 -  Update version to 6.0.
Rem     dtlai      10/16/96 -  Update changes for 2.5. 
Rem     dtlai      03/31/95 -  . 
Rem     rshoup     11/21/94 -  Creation 
Rem     rshoup     11/21/94 -  Reorder table drops; rename to brwdrs20.sql. 
Rem     rshoup     10/11/94 -  Creation 

set termout on
PROMPT 
PROMPT  Dropping Oracle Query Builder Saved Query tables...
PROMPT
set termout off

spool brwdrs60.log

drop public synonym browser_seq;

drop public synonym browser_grants;
drop public synonym browser_docs;
drop public synonym browser_all_docs;
drop public synonym browser_docs_granted;
drop public synonym browser_docs_sql;

drop sequence browser_seq;

drop view browser_grants;
drop view browser_docs;
drop view browser_all_docs;
drop view browser_docs_sql;
drop view browser_docs_granted;

drop table browser_grants_;
drop table browser_docs_sql_;
drop table browser_docs_;

spool off

set termout on
PROMPT 
PROMPT  Done.
PROMPT
PROMPT  The log file for reference is brwdrs60.log.
PROMPT
set termout off


