rem 
rem $Id: frm4drop.sql,v 1.1 1999/01/06 21:31:11 oraforms Exp $ 
rem 
Rem  Copyright (c) 1991 by Oracle Corporation 
Rem    NAME
Rem      frm4drop.sql - 
Rem    DESCRIPTION
Rem      Drops the table and view definitions for Forms 4
Rem    RETURNS
Rem 
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    MODIFIED   (MM/DD/YY)
Rem     kyue       08/18/93 -  drop synonym FRM40_Namelist 
Rem     kyue       01/08/93 -  get rid of dropping doc 
Rem     rgiljum    12/07/92 -  Creation 
Rem     bhill      09/04/92 -  scrollbar work 
Rem     pkuhn      09/03/92 -  Add synonym for FRM40__MNUAPP 
Rem     kyue       07/22/92 -  adding table for library external location 
Rem     kmallory   05/28/92 -  Creation 
Rem     kmallory   05/28/92 -  Creation 

rem
rem
rem  SQL*Forms 4.0 create table script
rem
rem

rem 
rem 
rem  Drop all tables
rem
rem
rem
drop table FRM40__REF;
drop table FRM40__TEXT;
drop table FRM40__APP;
drop table FRM40__BLK;
drop table FRM40__RELATION;
drop table FRM40__TRG;
drop table FRM40__V2TRG;
drop table FRM40__ITM;
drop table FRM40__RBT;
drop table FRM40__ALERT;
drop table FRM40__LOV;
drop table FRM40__LOVCOL;
drop table FRM40__RGPCOL;
drop table FRM40__EDITOR;
drop table FRM40__GRP;
drop table FRM40__RGP;
drop table FRM40__FRMPAR;
drop table FRM40__VA;
drop table FRM40__VIEW;
drop table FRM40__WINDOW;
drop table FRM40__NAMELIST;
drop table FRM40__VS;
drop table FRM40__SB;
drop table FRM40__MNUAPP;
drop table FRM40__MNUMNU;
drop table FRM40__MNUITM;
drop table FRM40__MNUPAR;
drop table FRM40__MNUUSER;
drop table FRM40__MNUGRP;
drop table FRM40__LIBEXTLOC;
rem 
rem
rem Drop all views
rem
rem
rem
drop view FRM40_REF;
drop view FRM40_TEXT;
drop view FRM40_APP;
drop view FRM40_BLK;
drop view FRM40_RELATION;
drop view FRM40_TRG;
drop view FRM40_V2TRG;
drop view FRM40_ITM;
drop view FRM40_RBT;
drop view FRM40_ALERT;
drop view FRM40_LOV;
drop view FRM40_LOVCOL;
drop view FRM40_RGPCOL;
drop view FRM40_EDITOR;
drop view FRM40_GRP;
drop view FRM40_RGP;
drop view FRM40_FRMPAR;
drop view FRM40_VA;
drop view FRM40_VIEW;
drop view FRM40_WINDOW;
drop view FRM40_NAMELIST;
drop view FRM40_VS;
drop view FRM40_SB;
drop view FRM40_MNUAPP;
drop view FRM40_MNUMNU;
drop view FRM40_MNUITM;
drop view FRM40_MNUPAR;
drop view FRM40_MNUUSER;
drop view FRM40_MNUGRP;
drop view FRM40_LIBEXTLOC;
rem
rem
rem Drop all synonym
rem
rem
rem
drop public synonym FRM40_REF;
drop public synonym FRM40_TEXT;
drop public synonym FRM40_APP;
drop public synonym FRM40_BLK;
drop public synonym FRM40_RELATION;
drop public synonym FRM40_TRG;
drop public synonym FRM40_V2TRG;
drop public synonym FRM40_ITM;
drop public synonym FRM40_RBT;
drop public synonym FRM40_ALERT;
drop public synonym FRM40_LOV;
drop public synonym FRM40_LOVCOL;
drop public synonym FRM40_RGPCOL;
drop public synonym FRM40_EDITOR;
drop public synonym FRM40_GRP;
drop public synonym FRM40_RGP;
drop public synonym FRM40_FRMPAR;
drop public synonym FRM40_VA;
drop public synonym FRM40_VIEW;
drop public synonym FRM40_WINDOW;
drop public synonym FRM40_NAMELIST;
drop public synonym FRM40_VS;
drop public synonym FRM40_SB;
drop public synonym FRM40__MNUAPP;
drop public synonym FRM40_MNUAPP;
drop public synonym FRM40_MNUMNU;
drop public synonym FRM40_MNUITM;
drop public synonym FRM40_MNUPAR;
drop public synonym FRM40_MNUUSER;
drop public synonym FRM40_MNUGRP;
drop public synonym FRM40_LIBEXTLOC;
drop public synonym FRM40__NAMELIST;

exit;
