Deletes the table
notes
with its content
DROP TABLE notes;
If the table does not exist, it will generate the following error:
#1051 - Unknown table 'notes
Deletes several tables at the same time
DROP TABLE notes, students;
Deletes the table if exists, otherwise it will not generate an error
DROP TABLE IF EXISTS notes;
Note: There is no undo. Once we delete, the table is gone
by Valeri Tandilashvili
4 years ago
MySQL
DROP
Full MySQL Course for Beginners
1
Pro tip: use ```triple backticks around text``` to write in code fences