MySQL Basics In Pictures
  1. At the mysql> prompt, type:

    DROP TABLE name;

    then press ENTER.
  2. Type:

    SHOW TABLES;

    then press ENTER.

    The table name has been dropped, or deleted, from the us_presidents database:

    If you hadn't made a backup of the us_presidents database and put it in your backups directory, the table name would be gone forever.