dropCheckConstraint
Note: This is a Liquibase Pro Change Type, so you need a Liquibase Pro License Key to use it.
Drops an existing check constraint.
Run dropCheckConstraint
To run this Change Type, follow these steps:
Add the Change Typento 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
Available attributes
Name | Description | Required for | Supports | Since |
| Name of the catalog | all | 3.0 | |
| Name of the constraint | all | all | |
| Name of the schema | all | ||
| Name of the table to drop the check constraint from | all | all |
Database support
Database | Notes | |
DB2/LUW | Supported | No |
DB2/z | Supported | No |
Derby | Not Supported | No |
Firebird | Not Supported | No |
Google BigQuery | Supported | No |
H2 | Not Supported | No |
HyperSQL | Not Supported | No |
INGRES | Not Supported | No |
Informix | Not Supported | No |
MariaDB | Not Supported | No |
MySQL 5.7 | Not Supported | No |
MySQL 8.0 | Supported | No |
Oracle | Supported | No |
PostgreSQL | Supported | No |
Snowflake | Not Supported | No |
SQL Server | Supported | No |
SQLite | Not Supported | No |
Sybase | Not Supported | No |
Sybase Anywhere | Not Supported | No |
dropCheckConstraint examples
--liquibase formatted sql
--changeset liquibase-docs:dropCheckConstraint-example
ALTER TABLE cat.[public].person DROP CONSTRAINT const_name;