Use DROP TABLE to delete a table - Hologres - Alibaba Cloud Documentation Center

Deletes one or more tables from the database.

Syntax

DROP TABLE [ IF EXISTS ] table_name [, ...];

DROP TABLE supports deleting multiple tables in a single statement by passing a comma-separated list of table names.

Parameters

Parameter	Description
`IF EXISTS`	Suppresses the error if the table does not exist. Without this option, dropping a nonexistent table returns `ERROR: table "non_exist_table" does not exist`.
`table_name`	The name of the table to delete.

Usage notes

Before dropping a table, check whether any views depend on it. Dropping a table that a view references causes the DROP TABLE statement to fail with the following error:

ERROR: cannot drop table xxx because other objects depend on it.
Detail: view xxx depends on table xxx.
Hint: Use DROP ... CASCADE to drop the dependent objects too.

If dependent views exist, use CASCADE to drop the table and all its dependent views together, or drop the views first before dropping the table.

Examples

Drop a single table:

DROP TABLE holo_test;

Drop multiple tables at once:

DROP TABLE table1, table2, table3;

Drop a table without raising an error if it does not exist:

DROP TABLE IF EXISTS holo_test;

Drop a table and all dependent views:

DROP TABLE IF EXISTS holo_test CASCADE;

Delete a table using HoloWeb

To delete a table visually, use the HoloWeb console:

Go to the HoloWeb page. For more information, see Connect to HoloWeb and run a query.
In the top menu bar of the HoloWeb page, click Metadata Management.
In the Instances Connected list on the left side of the Metadata Management page, right-click the table and select Delete Table.
In the dialog box, click OK.