Deleting a table

To delete a table, type the following command:

DROP TABLE table_name;

Once the table is deleted, the data inside it cannot be recovered.

We can view the current table using the show tables command, which gives all the tables inside the database:

SHOW tables;

After deleting the table, use the following commands: DROP TABLE details; Query OK, 0 rows affected (0.02 sec)

SHOW tables;

The output will be:

Empty set (0.00 sec)