home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a522 / 6.ddi / SRW_DCEN.SQL < prev    next >
Encoding:
Text File  |  1990-06-19  |  1.6 KB  |  51 lines
  1. rem  +----------------------------------------------------------------+
  2. rem  |  SRW_DCEN.SQL -- DROP CENTRAL SQL*ReportWriter TABLES          |
  3. rem  |                                                                |
  4. rem  |  This script is used to drop the centally located tables in a  |
  5. rem  |  Version 6 with transaction option RDBMS.                      |
  6. rem  |  The reports should be unloaded (dumprep) or the tables        |
  7. rem  |  exported (exp) before using this script.                      |
  8. rem  +----------------------------------------------------------------+
  9.  
  10. delete from system.product_access where product = 'SQL*ReportWriter';
  11.  
  12. drop table srw__report;
  13. drop table srw__ste;
  14. drop table srw__query;
  15. drop table srw__fkey;
  16. drop table srw__group;
  17. drop table srw__field;
  18. drop table srw__summary;
  19. drop table srw__text;
  20. drop table srw__text_long;
  21. drop table srw__param;
  22.  
  23. drop view srw_grant;
  24. drop view srw_granted;
  25. drop view srw_report;
  26. drop view srw_ste;
  27. drop view srw_query;
  28. drop view srw_fkey;
  29. drop view srw_group;
  30. drop view srw_field;
  31. drop view srw_summary;
  32. drop view srw_text;
  33. drop view srw_text_long;
  34. drop view srw_param;
  35.  
  36. drop sequence srw_next_appid;
  37.  
  38. drop public synonym srw_grant;
  39. drop public synonym srw_granted;
  40. drop public synonym srw_report;
  41. drop public synonym srw_next_appid;
  42. drop public synonym srw_ste;
  43. drop public synonym srw_query;
  44. drop public synonym srw_fkey;
  45. drop public synonym srw_group;
  46. drop public synonym srw_field;
  47. drop public synonym srw_summary;
  48. drop public synonym srw_text;
  49. drop public synonym srw_text_long;
  50. drop public synonym srw_param;
  51.