Facebook
From Zunied, 11 Months ago, written in Oracle 8.
Embed
Download Paste or View Raw
Hits: 153
  1. DROP TABLE table_name;
  2. DROP INDEX ord_customer_ix_demo;
  3. DROP TRIGGER hr.salary_check;
  4. DROP PUBLIC SYNONYM customers;
  5.  
  6. --trigger
  7. DROP TRIGGER USRNET.TRG_TQR_US_TRX_REGISTER_HIS;
  8. ---index
  9. DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_REF;
  10. DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_trid;
  11. DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_tid;
  12. DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_mid;
  13. DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_mid_tid;
  14. DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_entry_dt;
  15.  
  16.  
  17. ---table his
  18. DROP TABLE TQR_US_TRX_REGISTER_HIS;
  19. DROP PUBLIC SYNONYM TQR_US_TRX_REGISTER_HIS;
  20.  
  21. ---table
  22. DROP TABLE TQR_US_TRX_REGISTER;
  23. DROP PUBLIC SYNONYM TQR_US_TRX_REGISTER;