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;