DROP TABLE table_name;
DROP INDEX ord_customer_ix_demo;
DROP TRIGGER hr.salary_check; 
DROP PUBLIC SYNONYM customers; 

--trigger
DROP TRIGGER USRNET.TRG_TQR_US_TRX_REGISTER_HIS; 
---index
DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_REF;
DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_trid;
DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_tid;
DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_mid;
DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_mid_tid;
DROP INDEX IND_TQR_US_TRX_REGISTER_HIS_entry_dt;


---table his
drop table TQR_US_TRX_REGISTER_HIS;
DROP PUBLIC SYNONYM TQR_US_TRX_REGISTER_HIS;

---table
drop table TQR_US_TRX_REGISTER;
DROP PUBLIC SYNONYM TQR_US_TRX_REGISTER;