Copy to clipboard

delete

Last updated: July 14, 2025

Deletes data from an existing table.

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	Multiple allowed
`where`	Defines the `WHERE` condition string		all	no
`whereParams`	Parameters for the `WHERE` condition. The parameters are inserted in the order they are defined in place of the `:name` and `:value` placeholders. See the generated SQL sample below.		all	no

Name	Name of the attribute
`value`	A value of the attribute. Note: If it is not set, then the first `valueXXX` defined is used in the order they appear.
`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.

--liquibase formatted sql
--changeset liquibase-docs:delete-example
DELETE FROM cat.person
WHERE
  name = 'Bob';

--liquibase formatted sql
--changeset liquibase-docs:delete-example
DELETE FROM cat.person
WHERE
  name = 'Bob';