REM
REM  $Id: srw6drop.sql,v 1.1 1998/11/03 07:00:39 yxia Exp $
REM
REM  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
REM 
REM  srw2dcen.sql
REM
REM  This script drops the SQL*ReportWriter storage tables from the account
REM  in which they reside (usually SYSTEM).
REM

REM  +------------------------------------------------------------------------+
REM  |  SRW2_MODULE - View on Developer/2000 module table                     |
REM  +------------------------------------------------------------------------+

DROP VIEW srw2_module;
DROP PUBLIC SYNONYM srw2_module;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_ANCHOR - Layout Anchor                                           |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__anchor;
DROP VIEW srw2_anchor;
DROP PUBLIC SYNONYM srw2_anchor;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_BOILERPLATE - Layout Boilerplate                                 |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__boilerplate;
DROP VIEW srw2_boilerplate;
DROP PUBLIC SYNONYM srw2_boilerplate;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_TEXT_segment - A chunk of text boilerplate                       |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__text_segment;
DROP VIEW srw2_text_segment;
DROP PUBLIC SYNONYM srw2_text_segment;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_BUTTON - Layout Button                                           |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__button;
DROP VIEW srw2_button;
DROP PUBLIC SYNONYM srw2_button;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_COLUMN - Data Model Column                                       |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__column;
DROP VIEW srw2_column;
DROP PUBLIC SYNONYM srw2_column;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_DATA_MODEL - Data Model Header Record                            |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__data_model;
DROP VIEW srw2_data_model;
DROP PUBLIC SYNONYM srw2_data_model;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_FIELD - Layout Field                                             |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__field;
DROP VIEW srw2_field;
DROP PUBLIC SYNONYM srw2_field;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_FRAME - Layout Frame/Repeating Frame                             |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__frame;
DROP VIEW srw2_frame;
DROP PUBLIC SYNONYM srw2_frame;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_GROUP_NODE - Template Group Node                                 |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__group_node;
DROP VIEW srw2_group_node;
DROP PUBLIC SYNONYM srw2_group_node;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_GROUP - Data Model Group                                         |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__group;
DROP VIEW srw2_group;
DROP PUBLIC SYNONYM srw2_group;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_HYPERLINK - hyperlink object for layout objects                  |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__hyperlink;
DROP VIEW srw2_hyperlink;
DROP PUBLIC SYNONYM srw2_hyperlink;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_FORMAT_EXCEPTION - Format Exception object for layout objects    |
REM  +------------------------------------------------------------------------+
 
DROP TABLE srw2__format_exception;
DROP VIEW srw2_format_exception;
DROP PUBLIC SYNONYM srw2_format_exception;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_JAVA_APPLET - Java Applet object for layout objects              |
REM  +------------------------------------------------------------------------+
 
DROP TABLE srw2__java_applet;
DROP VIEW srw2_java_applet;
DROP PUBLIC SYNONYM srw2_java_applet;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_JAVA_PROPERTIES - Java Properties object for layout objects      |
REM  +------------------------------------------------------------------------+
 
DROP TABLE srw2__java_properties;
DROP VIEW srw2_java_properties;
DROP PUBLIC SYNONYM srw2_java_properties;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_LAYOUT_GROUP - Layout Group Header Record                        |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__layout_group;
DROP VIEW srw2_layout_group;
DROP PUBLIC SYNONYM srw2_layout_group;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_LINK - Data Model Parent-Child Link                              |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__link;
DROP VIEW srw2_link;
DROP PUBLIC SYNONYM srw2_link;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_LAYOUT - Layout Header Record                                    |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__layout;
DROP VIEW srw2_layout;
DROP PUBLIC SYNONYM srw2_layout;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_BODY_LOCATION - Location of each page body  |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__body_location;
DROP VIEW srw2_body_location;
DROP PUBLIC SYNONYM srw2_body_location;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_MATRIX - Layout Matrix                                           |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__matrix;
DROP VIEW srw2_matrix;
DROP PUBLIC SYNONYM srw2_matrix;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_OG_DOCUMENT - Layout Oracle Graphics Document/Chart              |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__og_document;
DROP VIEW srw2_og_document;
DROP PUBLIC SYNONYM srw2_og_document;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_OGD_COLUMN_MAP - Layout Oracle Graphics Document Column Map      |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__ogd_column_map;
DROP VIEW srw2_ogd_column_map;
DROP PUBLIC SYNONYM srw2_ogd_column_map;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_PARAM_FORM - Parameter Form Header Record                        |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__param_form;
DROP VIEW srw2_param_form;
DROP PUBLIC SYNONYM srw2_param_form;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_QUERY - Data Model Query                                         |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__query;
DROP VIEW srw2_query;
DROP PUBLIC SYNONYM srw2_query;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_ELEMENT - Select Expression or Parameter in a Query              |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__element;
DROP VIEW srw2_element;
DROP PUBLIC SYNONYM srw2_element;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_DISPLAY_TAG - Display Information for a Layout Object            |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__display_tag;
DROP VIEW srw2_display_tag;
DROP PUBLIC SYNONYM srw2_display_tag;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_LISTS - Lists - generally available list storage table           |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__lists;
DROP VIEW srw2_lists;
DROP PUBLIC SYNONYM srw2_lists;


REM  +------------------------------------------------------------------------+
REM  |  SRW2_DISTRIBUTION - Distribution object for layout objects            |
REM  +------------------------------------------------------------------------+

DROP TABLE srw2__distribution;
DROP VIEW srw2_distribution;
DROP PUBLIC SYNONYM srw2_distribution;

COMMIT;
