SQL DROP TABLE Syntax – Listed by DBMS

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.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

MySQL

From the MySQL 5.7 Reference Manual:

DROP [TEMPORARY] TABLE [IF EXISTS]
    tbl_name [, tbl_name] ...
    [RESTRICT | CASCADE]

Note that when a table is dropped, user privileges on the table are not automatically dropped.

SQL Server

From the Transact-SQL Reference:

DROP TABLE [ database_name . [ schema_name ] . | schema_name . ]
        table_name [ ,...n ] [ ; ]

PostgreSQL

From the PostgreSQL 9.5 Manual:

DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

Oracle Database

From the Oracle Database Online Documentation 12c Release 1 (12.1):

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.