/*==============================================================*/
/* DBMS name: ORACLE Version 11g */
/* Created on: 3/10/2013 6:03:53 PM */
/*==============================================================*/

alter table CONDUCTTEST
drop constraint FK_CONDUCTT_CONDUCTTE_AIRPLANE;

alter table CONDUCTTEST
drop constraint FK_CONDUCTT_CONDUCTTE_SENIOR_T;

alter table CONDUCTTEST
drop constraint FK_CONDUCTT_CONDUCTTE_TESTINFO;

alter table CONDUCTTEST
drop constraint FK_CONDUCTT_CONDUCTTE_TECHNICI;

alter table SENIOR_TECHNICIAN
drop constraint FK_SENIOR_T_INHERITAN_TECHNICI;

alter table SERVES
drop constraint FK_SERVES_SERVES_FLIGHT;

alter table SERVES
drop constraint FK_SERVES_SERVES2_AIRPLANE;

alter table SERVICE
drop constraint FK_SERVICE_SERVICE_TECHNICI;

alter table SERVICE
drop constraint FK_SERVICE_SERVICE2_FLIGHT;

alter table SERVICE
drop constraint FK_SERVICE_SERVICE3_SENIOR_T;

alter table TECHNICIAN
drop constraint FK_TECHNICI_INHERITAN_EMPLOYEE;

alter table TECHNICIAN
drop constraint FK_TECHNICI_SUPERVISE_SENIOR_T;

alter table TRAFFIC_CONTROLLER
drop constraint FK_TRAFFIC__INHERITAN_EMPLOYEE;

alter table FLIGHTDAY
drop constraint FK_FLIGHTDAY;

drop table AIRPLANE cascade constraints;

drop index CONDUCTTEST4_FK;

drop index CONDUCTTEST3_FK;

drop index CONDUCTTEST2_FK;

drop index CONDUCTTEST_FK;

drop table CONDUCTTEST cascade constraints;

drop table EMPLOYEE cascade constraints;

drop table FLIGHT cascade constraints;

drop table FLIGHTDAY cascade constraints;

drop table SENIOR_TECHNICIAN cascade constraints;

drop index SERVES2_FK;

drop index SERVES_FK;

drop table SERVES cascade constraints;

drop index SERVICE3_FK;

drop index SERVICE2_FK;

drop index SERVICE_FK;

drop table SERVICE cascade constraints;

drop index SUPERVISE_FK;

drop table TECHNICIAN…