-- This SQL script is to clean all tables of the loading layer.
--                                               ft, 1999.04.22
spool loadRESET
-- now delete from CERA Core: LOVs
delete from NEW_ACCESS_CONSTRAINT;
delete from NEW_ACCESS_TYPE;
delete from NEW_AGGREGATION;
delete from NEW_CITATION_TYPE;
delete from NEW_CONNECT_TYPE;
delete from NEW_CONTACT_TYPE;
delete from NEW_CURRENTNESS_REF;
delete from NEW_ENTRY_TYPE;
delete from NEW_FEES;
delete from NEW_FORMAT;
delete from NEW_GENERAL_KEY;
delete from NEW_HOR_COORD_SYS;
delete from NEW_LOCATION;
delete from NEW_PRESENTATION;
delete from NEW_PROGRESS;
delete from NEW_PROJECT;
delete from NEW_REF_TYPE;
delete from NEW_SPATIAL_DATA_ORG;
delete from NEW_TOPIC;
delete from NEW_UNIT;
delete from NEW_USE_CONSTRAINT;
delete from NEW_VER_COORD_SYS;
-- now delete from CERA Core: Entities, used like LOVs
delete from NEW_CITATION;
delete from NEW_INSTITUTE;
delete from NEW_PERSON;
-- now delete from CERA Module DATA_ACCESS
delete from NEW_ACCESS_STRUCTURE;
delete from NEW_STORAGE;
-- now delete from CERA Module MODEL_INPUT
delete from NEW_MODEL_TYPE;
delete from NEW_MODEL;
-- now delete from LOAD_* :
delete from LOAD_CONTA;
delete from LOAD_COVER;
delete from LOAD_DISTR;
delete from LOAD_KEY_C;
delete from LOAD_MODEL;
delete from LOAD_PARAM;
delete from LOAD_PROCE;
delete from LOAD_REFER;
delete from LOAD_SPATI;
delete from LOAD_ENTRY;
spool off
