Drop table

You can drop single table

DROP TABLE IF EXISTS dept_emp;

If you want to drop multiple tables

DROP TABLE IF EXISTS dept_manager,
                     titles,
                     salaries, 
                     employees, 
                     departments;

Drop database

DROP DATABASE IF EXISTS employees;