delete
Deletes data from an existing table.
Available attributes
Name | Description | Required for | Supports | Since |
---|---|---|---|---|
catalogName
|
Name of the catalog | all | 3.0 | |
schemaName
|
Name of the schema | all | ||
tableName
|
Name of the table | all | all | |
where
|
all |
Nested properties
Name | Description | Required for | Supports | Multiple allowed |
---|---|---|---|---|
where
|
Allows to define the 'where' condition(s) string | all | no | |
whereParams
|
all | no |
Nested Element attributes:
Name | Name of the attribute |
---|---|
value
|
Value of the attribute.
Note: If not set, then the first valueXXX defined is used in the order
they appear. |
valueNumeric
|
integer value of the attribute. |
valueBoolean
|
boolean value of the attribute. |
valueDate
|
Date and/or Time value to set the attribute to. The value shall be specified in one of the following forms: "YYYY-MM-DD", "hh:mm:ss" or "YYYY-MM-DDThh:mm:ss". |
valueComputed
|
A value that is returned from a function or procedure call. This attribute shall contain the function name to call. |
valueSequenceNext
|
Name of the sequence which next value is used |
valueSequenceCurrent
|
Name of the sequence which current value is used |

<changeSet author="liquibase-docs" id="delete-example">
<delete catalogName="cat"
schemaName="public"
tableName="person">
<where>name='Bob'</where>
</delete>
</changeSet>

changeSet:
id: delete-example
author: liquibase-docs
changes:
- delete:
catalogName: cat
schemaName: public
tableName: person
where: name='Bob'

{
"changeSet": {
"id": "delete-example",
"author": "liquibase-docs",
"changes": [{
"delete": {
"catalogName": "cat",
"schemaName": "public",
"tableName": "person",
"where": "name='Bob' and :name=:value or id=:value",
"whereParams": [{
"param": {
"name": "id",
"value": "str"
}
},{
"param": {
"valueNumeric": 123
}
}]
}
}]
}
}

DELETE FROM cat.person WHERE name='Bob';
Database support
Database | Notes | Auto rollback |
---|---|---|
DB2/LUW | Supported | No |
DB2/z | Supported | No |
Derby | Supported | No |
Firebird | Supported | No |
H2 | Supported | No |
HyperSQL | Supported | No |
INGRES | Supported | No |
Informix | Supported | No |
MariaDB | Supported | No |
MySQL | Supported | No |
Oracle | Supported | No |
PostgreSQL | Supported | No |
Snowflake | Supported | No |
SQL Server | Supported | No |
SQLite | Supported | No |
Sybase | Supported | No |
Sybase Anywhere | Supported | No |