Before you can remove a table, you must remove all its dependent objects (indexes, materialized views, etc.).

Syntax

DROP TABLE [ IF EXISTS ] [schema_name.]table_name [ CASCADE ];

Parameters

ParameterDescription
schemaSpecify the name of a schema to remove the table in that schema. You can use SHOW SCHEMAS to get a list of all available schemas. If you don’t specify a schema, the specified source in the default schema public will be removed.
tableThe name of the table to remove. You can use SHOW TABLES to get a list of all available tables.
CASCADE optionIf this option is specified, all objects (such as materialized views) that depend on the table, and in turn all objects that depend on those objects will be dropped.

Examples

This statement removes the taxi_trips table in the default schema (public) from the database:

DROP TABLE taxi_trips;

This statement removes the taxi_trips table in the rw_schema schema from the database:

DROP TABLE IF EXISTS rw_schema.taxi_trips;