Note_Tech

All technological notes.

---

Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham

SQL - DELETE TABLE

Back

• SQL - DELETE TABLE
  • DROP TABLE (To Recyclebin)

---

DROP TABLE (To Recyclebin)

To remove a table from database.

• Syntax:

-- remove a given table to recyclebin
DROP TABLE tablename;

• Always exercise caution when deleting especially when it is a table.

• In addition, any index that has been created based on the table is also dropped.

• Any dropped table was permanently removed, and could only be recovered from backup.

---

TOP