This article lists the SQL
DROP TABLE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
From the MySQL 5.7 Reference Manual:
DROP [TEMPORARY] TABLE [IF EXISTS]
tbl_name] ... [RESTRICT | CASCADE]
Note that when a table is dropped, user privileges on the table are not automatically dropped.
From the Transact-SQL Reference:
DROP TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name [ ,...n ] [ ; ]
From the PostgreSQL 9.5 Manual:
DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DROP TABLE [ schema. ] table [ CASCADE CONSTRAINTS ] [ PURGE ] ;
Using the GUI
Dropping tables can also be done via the GUI in each of the database management systems, or by using any of the GUI tools available for use with that product.
For example, MySQL Workbench can be used with MySQL.