home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a523 / 11.ddi / IADDROP.SQL < prev    next >
Encoding:
Text File  |  1990-11-29  |  1.3 KB  |  95 lines
  1. Rem Copyright (c) 1988 by Oracle Corporation
  2. Rem NAME
  3. Rem    IADDROP.SQL - Drop SQL*Forms' tables, views and synonyms.
  4. Rem  FUNCTION
  5. Rem  NOTES
  6. Rem  MODIFIED
  7. Rem   Hsi        11/07/89 - Creation
  8. Rem
  9.  
  10. spool iaddrop.lis
  11.  
  12. Rem
  13. Rem  Drop all tables 
  14. Rem 
  15. drop table form_app_
  16. /
  17. drop table form_blk_
  18. /
  19. drop table form_fld_
  20. /
  21. drop table form_trigger_
  22. /
  23. drop table form_trg_
  24. /
  25. drop table form_sqltxt_
  26. /
  27. drop table form_page_
  28. /
  29. drop table form_map_
  30. /
  31. drop table form_comment_
  32. /
  33. drop table form_reference_
  34. /
  35. drop table form_procedure_
  36. /
  37. drop table form_user_
  38. /
  39. drop cluster form_tables
  40. /
  41.  
  42. Rem
  43. Rem  Drop views
  44. Rem
  45. drop view form_app
  46. /
  47. drop view form_blk
  48. /
  49. drop view form_fld
  50. /
  51. drop view form_trigger
  52. /
  53. drop view form_trg
  54. /
  55. drop view form_sqltxt
  56. /
  57. drop view form_page
  58. /
  59. drop view form_map
  60. /
  61. drop view form_comment
  62. /
  63. drop view form_reference
  64. /
  65. drop view form_procedure
  66. /
  67. Rem
  68. Rem  Drop synonyms
  69. Rem
  70. drop public synonym form_app
  71. /
  72. drop public synonym form_blk
  73. /
  74. drop public synonym form_fld
  75. /
  76. drop public synonym form_page
  77. /
  78. drop public synonym form_map
  79. /
  80. drop public synonym form_sqltxt
  81. /
  82. drop public synonym form_trg
  83. /
  84. drop public synonym form_trigger
  85. /
  86. drop public synonym form_comment
  87. /
  88. drop public synonym form_reference
  89. /
  90. drop public synonym form_procedure
  91. /
  92.  
  93. spool off
  94.  
  95.