DROP TABLE no_such_table;
---

DROP PROCEDURE proc_name;

---

DROP TABLE no_such_table CASCADE;

---

DROP TABLE no_such_table RESTRICT;

---

DROP TABLE no_such_table PURGE;

---

DROP VIEW view;

---