Overview

You can use the PostgreSQL DROP TABLE command to delete a partitioned table definition, the partitions and subpartitions of that table, and the table content. Syntax:
DROP TABLE table_name

Description

The DROP TABLE command deletes an entire table and the data stored in the table. When you delete a table, all partitions and subpartitions of the table are also deleted.

To use the DROP TABLE command, you must be the owner of the partitioning root, a member of a group that owns the table, the schema owner, or a database superuser.

Parameters

Parameter Description
table_name The name (optionally schema-qualified) of the partitioned table.

Example

To delete a table, connect to the controller node (the host of the partitioning root), and run the DROP TABLE command. For example, to delete the sales table, run the following command:
DROP TABLE sales;
The server will confirm that the table has been dropped:
acctg=# drop table sales;
DROP TABLE
acctg=#		

For more information about the DROP TABLE command, see the PostgreSQL core documentation.