DROP is typically used to delete a database or table from the DBMS.
To delete the foo table from the current database:
DROP TABLE foo;