rem 
rem $Header: /forms41/prd/RCS/summdrop.sql,v 1.1 1993/11/17 13:17:23 oraforms Exp $ 
rem 
Rem  Copyright (c) 1993 by Oracle Corporation 
Rem    NAME
Rem      summdrop.sql - <one-line expansion of the name>
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem    RETURNS
Rem 
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    MODIFIED   (MM/DD/YY)
Rem     smuench    05/03/93 -  Creation 
set feedback off
prompt Dropping tables and sequences.  Please wait.

Rem Drop sequences.

DROP SEQUENCE s_customer_id;
DROP SEQUENCE s_dept_id;
DROP SEQUENCE s_emp_id;
DROP SEQUENCE s_image_id;
DROP SEQUENCE s_longtext_id;
DROP SEQUENCE s_ord_id;
DROP SEQUENCE s_product_id;
DROP SEQUENCE s_region_id;
DROP SEQUENCE s_warehouse_id;

Rem Drop foreign key constraints.

ALTER TABLE s_dept DROP CONSTRAINT s_dept_region_id_fk;
ALTER TABLE s_emp DROP CONSTRAINT s_emp_manager_id_fk;
ALTER TABLE s_emp DROP CONSTRAINT s_emp_dept_id_fk;
ALTER TABLE s_emp DROP CONSTRAINT s_emp_title_fk;
ALTER TABLE s_customer DROP CONSTRAINT s_sales_rep_id_fk;
ALTER TABLE s_customer DROP CONSTRAINT s_customer_region_id_fk;
ALTER TABLE s_ord DROP CONSTRAINT s_ord_customer_id_fk;
ALTER TABLE s_ord DROP CONSTRAINT s_ord_sales_rep_id_fk;
ALTER TABLE s_product DROP CONSTRAINT s_product_image_id_fk;
ALTER TABLE s_product DROP CONSTRAINT s_product_longtext_id_fk;
ALTER TABLE s_item DROP CONSTRAINT s_item_ord_id_fk;
ALTER TABLE s_item DROP CONSTRAINT s_item_product_id_fk;
ALTER TABLE s_warehouse DROP CONSTRAINT s_warehouse_manager_id_fk;
ALTER TABLE s_warehouse DROP CONSTRAINT s_warehouse_region_id_fk;
ALTER TABLE s_inventory DROP CONSTRAINT s_inventory_product_id_fk;
ALTER TABLE s_inventory DROP CONSTRAINT s_inventory_warehouse_id_fk;

Rem Drop tables.

DROP TABLE s_customer;
DROP TABLE s_dept;
DROP TABLE s_emp;
DROP TABLE s_image;
DROP TABLE s_inventory;
DROP TABLE s_item;
DROP TABLE s_longtext;
DROP TABLE s_ord;
DROP TABLE s_product;
DROP TABLE s_region;
DROP TABLE s_title;
DROP TABLE s_warehouse;

prompt Tables and sequences dropped.
set feedback on
