Copy to clipboard

dropTable

Drops an existing table from your database.

To run this Change Type, follow these steps:

Add the Change Type to your changeset, as shown in the examples on this page.
Specify any required attributes. Use the table on this page to see which ones your database requires.
Deploy your changeset by running the update command:liquibase update

Name	Description	Required for	Supports	Since
`cascadeConstraints`	Boolean. Adds the `CASCADE CONSTRAINTS` SQL to the statement		all
`catalogName`	Name of the catalog		all	3.0
`schemaName`	Name of the schema		all
`tableName`	Name of the table to drop	all	all

--liquibase formatted sql
--changeset liquibase-docs:dropTable-example
DROP TABLE cat.person;

--liquibase formatted sql
--changeset liquibase-docs:dropTable-example
DROP TABLE cat.person;