home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a524 / 33.ddi / admin / iaddrop.sql < prev    next >
Encoding:
Text File  |  1991-03-04  |  1.1 KB  |  75 lines
  1. rem
  2. rem $Header: iaddrop.sql,v 3001200.1 89/12/05 14:16:44 rcs Exp $ iaddrop.sql Copyr (c) 1989 Oracle
  3. rem
  4. rem SQLFORMS3030012,DUA50:[FREEZE_SQLFORMS30.SQL.30012]
  5. Rem Copyright (c) 1988 by Oracle Corporation
  6. Rem NAME
  7. Rem    IADDROP.SQL - Drop SQL*Forms' tables, views and synonyms.
  8. Rem  FUNCTION
  9. Rem  NOTES
  10. Rem  MODIFIED
  11. Rem   Hsi        11/07/89 - Creation
  12. Rem
  13.  
  14. spool iaddrop.lis
  15.  
  16. Rem
  17. Rem  Drop all tables in the cluster
  18. Rem 
  19. drop cluster form_tables including tables
  20. /
  21.  
  22. Rem
  23. Rem  Drop views
  24. Rem
  25. drop view form_app
  26. /
  27. drop view form_blk
  28. /
  29. drop view form_fld
  30. /
  31. drop view form_trigger
  32. /
  33. drop view form_trg
  34. /
  35. drop view form_sqltxt
  36. /
  37. drop view form_page
  38. /
  39. drop view form_map
  40. /
  41. drop view form_comment
  42. /
  43. drop view form_reference
  44. /
  45. drop view form_procedure
  46. /
  47. Rem
  48. Rem  Drop synonyms
  49. Rem
  50. drop public synonym form_app
  51. /
  52. drop public synonym form_blk
  53. /
  54. drop public synonym form_fld
  55. /
  56. drop public synonym form_page
  57. /
  58. drop public synonym form_map
  59. /
  60. drop public synonym form_sqltxt
  61. /
  62. drop public synonym form_trg
  63. /
  64. drop public synonym form_trigger
  65. /
  66. drop public synonym form_comment
  67. /
  68. drop public synonym form_reference
  69. /
  70. drop public synonym form_procedure
  71. /
  72.  
  73. spool off
  74.  
  75.