annotationService-dropScript.sql 780 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. --
  2. -- Licensed Materials - Property of IBM
  3. --
  4. -- BI and PM: HTS
  5. --
  6. -- (c) Copyright IBM Corp. 2003, 2010.
  7. --
  8. -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  9. --
  10. DROP TABLE ANN_CONTEXT_DIMENSIONMEMBER
  11. GO
  12. DROP TABLE ANN_DIMENSION_METADATAITEM
  13. GO
  14. DROP TABLE ANN_DIMENSIONMEMBER_DATAITEM
  15. GO
  16. DROP TABLE ANN_MODEL_DIMENSION
  17. GO
  18. DROP TABLE ANN_METADATAITEM
  19. GO
  20. DROP TABLE ANN_DATAITEM
  21. GO
  22. DROP TABLE ANN_DIMENSIONMEMBER
  23. GO
  24. DROP TABLE ANN_DIMENSION
  25. GO
  26. DROP TABLE ANN_ANNOTATION_PROPS
  27. GO
  28. DROP TABLE ANN_ANNOTATION
  29. GO
  30. DROP TABLE ANN_ANNOTATION_TEXT
  31. GO
  32. DROP TABLE ANN_MODEL
  33. GO
  34. DROP TABLE ANN_CONTEXT
  35. GO
  36. DROP TABLE ANN_IDTABLE
  37. GO
  38. DROP TABLE ANN_VERSION
  39. GO