-- SQL script for dropping the CERA Module DATA_ACCESS

drop sequence SEQ_ACCESS_STRUCTURE;
drop sequence SEQ_STORAGE;
drop sequence SEQ_REC_STRUCTURE;
drop sequence SEQ_DATA_ACCESS;

alter table PARAMETER drop constraint PARA_DACC;
update      PARAMETER set DATA_ACCESS_ID = NULL;
drop  table DATA_ACCESS;

drop table ACCESS_STRUCTURE;
drop table STORAGE;
drop table REC_STRUCTURE;

drop synonym STORAGE1;
drop synonym STORAGE2;
drop synonym STORAGE3;
drop synonym STORAGE4;
