Skip to main content

DROP TABLE

Use the DROP TABLE command to remove a table from the database.

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

Syntax

DROP TABLE [schema_name.]table_name;

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.

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 rw_schema.taxi_trips;

Help us make this doc better!