rem 
rem $Id: godrop.sql,v 1.1 1998/01/02 23:18:06 bgutierr Exp $
rem 
Rem  Copyright (c) 1992 by Oracle Corporation 
Rem    NAME
Rem      godrp.sql - Graphocal Oracle Schema.
Rem    DESCRIPTION
Rem      Contains sql/plus calls to DROP and INDEX the ROS tables.
Rem    RETURNS
Rem      Nothing
Rem    NOTES
Rem    MODIFIED   (MM/DD/YY)
Rem     ewong      03/30/93 -  Removed exit statement 
Rem     fpun       12/04/92 -  add exit 
Rem     fpun       12/02/92 -  Creation 
Rem     fpun       12/02/92 -  delete output spool 
Rem     fpun       11/24/92 -  Creation 
Rem     jrhee      09/03/92 -  Add volume info to sound table 
Rem     jrhee      08/12/92 -  Add text_invisibility column to go__document tab
Rem     jrhee      07/06/92 -  Delete copyright info from go__document 
Rem     dlai       05/26/92 -  revise 
Rem     dlai       05/26/92 -  revise 
Rem     dlai       05/21/92 -  revise 
Rem     rquach     05/08/92 -  add new field to doc table 
Rem     rquach     03/16/92 -  change unique index to index for layer table. 
Rem     rquach     03/10/92 -  add ocl version number field. 
Rem     rquach     02/24/92 -  add security to go tables. 
Rem     rquach     02/12/92 -  schema change for new de stuff. 
Rem     jwu        02/10/92 -  add sound table 
Rem     rquach     02/10/92 -  Creation 

/*--------------------------*/
/* Drop go document table   */
/*--------------------------*/
drop table go__document;
drop view go_document;
drop public synonym go_document;


/*-----------------------*/
/* Drop go timer table   */
/*-----------------------*/
drop table go__timer;
drop view go_timer;
drop public synonym go_timer;


/*-----------------------*/
/* Drop go query table   */
/*-----------------------*/
drop table go__query;
drop view go_query;
drop public synonym go_query;


/*---------------------------*/
/* Drop go parameter table   */
/*---------------------------*/
drop table go__parameter;
drop view go_parameter;
drop public synonym go_parameter;


/*-------------------------------*/
/* Drop go visible layer table   */
/*-------------------------------*/
drop table go__vislayer;
drop view go_vislayer;
drop public synonym go_vislayer;


/*-----------------------*/
/* Drop go sound table   */
/*-----------------------*/
drop table go__sound;
drop view go_sound;
drop public synonym go_sound;


/*-----------------------*/
/* Drop go column table   */
/*-----------------------*/
drop table go__column;
drop view go_column;
drop public synonym go_column;


