rem  ---------------------------------------------------------------------
rem  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
rem
rem  NAME: rosdrop.sql
rem
rem  DESCRIPTION:
rem
rem  This script drops the Resource Object Store schema in a clients
rem  database.


/*----------------------*/
/* Drop ROSSTRUCTS view */
/*----------------------*/
drop view     ROSSTRUCTS;

/*----------------------*/
/* Drop ROSATTRIBS view */
/*----------------------*/
drop view     ROSATTRIBS;

/*-----------------------*/
/* Drop ROSSTRINGS table */
/*-----------------------*/
drop table    ROSSTRINGS;

/*----------------------*/
/* Drop ROSLFDESC table */
/*----------------------*/
drop table    ROSLFDESC;

/*----------------------*/
/* Drop ROSTFDESC table */
/*----------------------*/
drop table    ROSTFDESC;

/*----------------------------*/
/* Drop ROSLFDESC_ID sequence */
/*----------------------------*/
drop sequence ROSLFDESC_ID;

/*----------------------------*/
/* Drop ROSTFDESC_ID sequence */
/*----------------------------*/
drop sequence ROSTFDESC_ID;

/*-------------------------*/
/* Drop ROSSEQUENCES table */
/*-------------------------*/
drop table    ROSSEQUENCES;

/*----------------------*/
/* Drop ROSOBJMAP table */
/*----------------------*/
drop table    ROSOBJMAP;

/*---------------*/
/* Drop synonyms */
/*---------------*/
drop public synonym ROSSTRUCTS;
drop public synonym ROSATTRIBS;
drop public synonym ROSSTRINGS;
drop public synonym ROSLFDESC;
drop public synonym ROSTFDESC;
drop public synonym ROSOBJMAP;
drop public synonym ROSSEQUENCES;
drop public synonym ROSLFDESC_ID;
drop public synonym ROSTFDESC_ID;

