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

--
--    Licensed Materials - Property of IBM
--    
--    BI and PM: ANS
--    
--    (c) Copyright IBM Corp. 2003, 2010.
--    
--    US Government Users Restricted RigANS - 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;