Create the table:

CREATE TABLE pastries
  (
    name VARCHAR(50),
    quantity INT
  );

View tables:

SHOW TABLES;

View details of pastries table:

DESC pastries;

Delete the whole pastries table:

DROP TABLE pastries;