Deleting a table

Deleting a table is very easy indeed. But, because I don’t want you to have to reenter all the data for the classics table, let’s quickly create a new table, verify its existence, and then delete it. You can do this by typing the commands:

CREATE TABLE datatiedot(trash INT);
DESCRIBE datatiedot;
DROP TABLE datatiedot;
SHOW tables;

Leave a Reply

Your email address will not be published. Required fields are marked *