-- This SQL is for dropping the whole layer of CERA Loading Tables
--                                               ft, 1999.04.22
spool loadDROP
-- now drop tables for CERA Core: LOVs
drop table NEW_ACCESS_CONSTRAINT;
drop table NEW_ACCESS_TYPE;
drop table NEW_AGGREGATION;
drop table NEW_CITATION_TYPE;
drop table NEW_CONNECT_TYPE;
drop table NEW_CONTACT_TYPE;
drop table NEW_CURRENTNESS_REF;
drop table NEW_ENTRY_TYPE;
drop table NEW_FEES;
drop table NEW_FORMAT;
drop table NEW_GENERAL_KEY;
drop table NEW_HOR_COORD_SYS;
drop table NEW_LOCATION;
drop table NEW_PRESENTATION;
drop table NEW_PROGRESS;
drop table NEW_PROJECT;
drop table NEW_REF_TYPE;
drop table NEW_SPATIAL_DATA_ORG;
drop table NEW_TOPIC;
drop table NEW_UNIT;
drop table NEW_USE_CONSTRAINT;
drop table NEW_VER_COORD_SYS;
-- now drop tables for CERA Core: Entities, used like LOVs
drop table NEW_CITATION;
drop table NEW_INSTITUTE;
drop table NEW_PERSON;
-- now drop tables for CERA Module DATA_ACCESS
drop table NEW_ACCESS_STRUCTURE;
drop table NEW_STORAGE;
-- now drop tables for CERA Module MODEL_INPUT
drop table NEW_MODEL_TYPE;
drop table NEW_MODEL;
-- now drop table LOAD_* :
drop table LOAD_CONTA;
drop table LOAD_COVER;
drop table LOAD_DISTR;
drop table LOAD_KEY_C;
drop table LOAD_PARAM;
drop table LOAD_PROCE;
drop table LOAD_REFER;
drop table LOAD_SPATI;
drop table LOAD_MODEL;
drop table LOAD_ENTRY;
spool off

