analytics/configuration/schemas/ans/oracle/annotationService-dropScript.sql

--
--    Licensed Materials - Property of IBM
--    
--    BI and PM: HTS
--    
--    (c) Copyright IBM Corp. 2003, 2010.
--    
--    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
--    


DROP TABLE ANN_CONTEXT_DIMENSIONMEMBER;

DROP TABLE  ANN_DIMENSION_METADATAITEM;

DROP TABLE  ANN_DIMENSIONMEMBER_DATAITEM;

DROP TABLE  ANN_MODEL_DIMENSION;

DROP TABLE  ANN_METADATAITEM;

DROP TABLE  ANN_DATAITEM;

DROP TABLE  ANN_DIMENSIONMEMBER;

DROP TABLE  ANN_DIMENSION;

DROP TABLE  ANN_ANNOTATION_PROPS;

DROP TABLE  ANN_ANNOTATION;

DROP TABLE  ANN_ANNOTATION_TEXT;

DROP TABLE  ANN_MODEL;

DROP TABLE  ANN_CONTEXT;

DROP TABLE  ANN_IDTABLE;

DROP TABLE  ANN_VERSION;