BIMRL_drtab.sql

DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME='BIMRL_ELEMENT_&1';
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME='BIMRL_TOPO_FACE_&1';
DROP INDEX IDX_BIMRLELEM_GEOM_&1;
DROP INDEX IDX_BIMRLELEM_GEOMBB_&1;
DROP INDEX IDX_BIMRLELEM_GEOMBBC_&1;
DROP INDEX IDX_BIMRLELEM_GEOMFP_&1;
DROP INDEX IDX_BIMRLELEM_GEOMAX_&1;
DROP INDEX IDX_BIMRLELEM_GEOMMJX_&1;
DROP INDEX IDX_BIMRLELEM_GEOMMJY_&1;
DROP INDEX IDX_BIMRLELEM_GEOMMJZ_&1;
DROP INDEX IDX_TOPOF_POLYGON_&1;
DROP INDEX IDX_TOPOF_NORMAL_&1;
DROP INDEX IDX_TOPOF_CENTROID_&1;
DROP SEQUENCE seq_BIMRL_MODELINFO_&1;
DROP SEQUENCE seq_BIMRL_PARTGEOMETRY_&1;
DROP TABLE BIMRL_ELEMENT_&1 CASCADE CONSTRAINTS;
DROP TABLE BIMRL_OWNERHISTORY_&1 CASCADE CONSTRAINTS;
DROP TABLE BIMRL_SPATIALSTRUCTURE_&1  CASCADE CONSTRAINTS;
DROP TABLE BIMRL_MODELINFO_&1 CASCADE CONSTRAINTS;
DROP TABLE BIMRL_RELCONNECTION_&1 CASCADE CONSTRAINTS;
DROP TABLE BIMRL_PARTGEOMETRY_&1 CASCADE CONSTRAINTS;
DROP TABLE BIMRL_ELEMENTPROPERTIES_&1 CASCADE CONSTRAINTS;
DROP TABLE BIMRL_TYPEMATERIAL_&1 CASCADE CONSTRAINTS;
DROP TABLE BIMRL_ELEMENTMATERIAL_&1  CASCADE CONSTRAINTS;
DROP TABLE BIMRL_CLASSIFICATION_&1  CASCADE CONSTRAINTS;
DROP TABLE BIMRL_ELEMCLASSIFICATION_&1 CASCADE CONSTRAINTS;
DROP TABLE BIMRL_TYPCLASSIFICATION_&1 CASCADE CONSTRAINTS;
DROP TABLE BIMRL_TYPE_&1  CASCADE CONSTRAINTS;
DROP TABLE BIMRL_TYPEPROPERTIES_&1  CASCADE CONSTRAINTS;
DROP TABLE BIMRL_RELAGGREGATION_&1  CASCADE CONSTRAINTS;
DROP TABLE BIMRL_RELSPACEBOUNDARY_&1  CASCADE CONSTRAINTS;
DROP TABLE BIMRL_RELSPACEB_DETAIL_&1  CASCADE CONSTRAINTS;
DROP TABLE BIMRL_RELGROUP_&1  CASCADE CONSTRAINTS;
DROP TABLE BIMRL_ELEMENTDEPENDENCY_&1  CASCADE CONSTRAINTS;
DROP TABLE BIMRL_SPATIALINDEX_&1 CASCADE CONSTRAINTS;
DROP TABLE BIMRL_TOPO_FACE_&1 CASCADE CONSTRAINTS;
DROP VIEW BIMRL_PROPERTIES_&1;
DROP VIEW BIMRL_ELEMWOGEOM_&1;
DROP VIEW BIMRL_TOPOFACEV_&1;
DROP VIEW BIMRL_SPACEBOUNDARYV_&1;
DROP VIEW BIMRL_CLASSIFASSIGNMENT_&1;
DROP VIEW CIRCULATION_&1;