Скрипт drop_stuff.sql

-- *********************************************************************
-- Name: drop_stuff.sql
-- Purpose:
-- Author: Vladimir Begun
-- $Id$
-- TODO: XXX

PROMPT Dropping old objects...

SET FEEDBACK OFF
DROP SEQUENCE seq$lookup;
DROP TRIGGER trg$code_name;
DROP FUNCTION register_code_name;
DROP VIEW VIW$CURRENCY_ENGLISH;
DROP VIEW VIW$CURRENCY_RUSSIAN;
DROP VIEW VIW$PAYMENT_ENGLISH;
DROP VIEW VIW$PAYMENT_GERMAN;
DROP VIEW VIW$PAYMENT_RUSSIAN;
DROP VIEW VIW$SEX_ENGLISH;
DROP VIEW VIW$SEX_GERMAN;
DROP VIEW VIW$SEX_RUSSIAN;
DROP TABLE operation;
DROP TABLE account;
DROP TABLE person;
DROP TABLE code_name;
DROP TABLE lookup;
DROP TABLE category;
DROP TABLE lang;

SET FEEDBACK ON