delete
Deletes data from an existing table.
Run delete
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
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 |
Nested tags
Name | Description | Required for | Supports | Multiple allowed |
---|---|---|---|---|
where
|
Defines the |
all | no | |
whereParams
|
Parameters for the |
all | no |
Nested property attributes
Name | Name of the attribute |
---|---|
value
|
A value of the attribute.
Note: If it is not set, then the first |
valueNumeric
|
The integer value of the attribute. |
valueBoolean
|
The boolean value of the attribute. |
valueDate
|
The date and/or time value to set the attribute. The value should be specified in one of the
following forms: YYYY-MM-DD , hh:mm:ss , or YYYY-MM-DDThh:mm:ss . |
valueComputed
|
The value that is returned from a function or procedure call. Contains the function or column name to call. Differs from value by returning the value of the function or column you specify instead of the name of the function/column as a string. Can also perform operations on the returned value. |
valueSequenceNext
|
The name of the sequence in which the next value is used. |
valueSequenceCurrent
|
The name of the sequence in which the current value is used. |
Examples
--liquibase formatted sql
--changeset liquibase-docs:delete-example
DELETE FROM cat.person WHERE name='Bob';
databaseChangeLog:
- changeSet:
id: delete-example
author: liquibase-docs
changes:
- delete:
catalogName: cat
schemaName: public
tableName: person
where: name='Bob'
{
"databaseChangeLog": [
{
"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
}
}
]
}
}
]
}
}
]
}
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
xmlns:pro="http://www.liquibase.org/xml/ns/pro"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
http://www.liquibase.org/xml/ns/dbchangelog-ext
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd
http://www.liquibase.org/xml/ns/pro
http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd">
<changeSet author="liquibase-docs" id="delete-example">
<delete catalogName="cat"
schemaName="public"
tableName="person">
<where>name='Bob'</where>
</delete>
</changeSet>
</databaseChangeLog>
Database support
Database | Notes | Auto Rollback |
---|---|---|
DB2/LUW | Supported | No |
DB2/z | Supported | No |
Derby | Supported | No |
Firebird | Supported | No |
Google BigQuery | 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 |