rollback-to-date-sql

Last updated: January 21, 2026

The rollback-to-date-sql command is a helper command that allows you to inspect the SQL Liquibase will run while using the rollback-to-date command.

Uses

The rollback-to-date-sql command is typically used when you want to inspect the raw SQL before running the rollback-to-date command, so you can correct any issues that may arise before running the command.

Syntax

Before running the rollback-to-date-sql command, you can see the dates of all previous changes by running the history command.

Note: Unlike the rollback-to-date command, there is no impact to your database while using this command.

To run the rollback-to-date-sql command, specify the driver, classpath, and URL in the Liquibase properties file. You can also specify these properties in your command line.

Then run the rollback-to-date-sql command:

liquibase rollback-to-date-sql --date=2020-05-07 --changelog-file=example-changelog.xml

Parameters

Global parameters

Attribute	Definition	Requirement
`--output-file=<string>`	File path to where the command output will be written. If not specified, output goes to `STDOUT`. See `--output-file`.	Optional

Command parameters

Attribute	Definition	Requirement
`--changelog-file=<string>`	The root changelog	Required
`--date=<string>`	The date and time your database rolls back to. The date format is `YYYY-MM-DD HH:MM:SS` or `YYYY-MM-DD'T'HH:MM:SS`. However, it is possible to indicate the date or time only. Specify as `--date=myDate`. Positional format `<command> <date>` deprecated in 4.4+.	Required
`--url=<string>`	The JDBC database connection URL.	Required
`--change-exec-listener-class=<string>`	Fully-qualified class that specifies a `ChangeExecListener`.	Optional
`--change-exec-listener-properties-file=<string>`	Path to a properties file for the `ChangeExecListener` class.	Optional
`--context-filter=<string>`	Specifies the changeset contexts to match. Contexts are tags you can add to changesets to control which changesets are executed in any particular migration run. Note: If you use Liquibase 4.23.0 or earlier, use the syntax `--contexts` instead of `--context-filter`.	Optional
`--default-catalog-name=<string>`	Name of the default catalog to use for the database connection	Optional
`--default-schema-name=<string>`	Name of the default schema to use for the database connection. If `defaultSchemaName` is set, then objects do not have to be fully qualified. This means you can refer to just `mytable` instead of `myschema.mytable`. Note: In the properties file and `JAVA_OPTS` only: in 4.18.0 and earlier, specify this parameter using the syntax `defaultSchemaName`. In 4.19.0 and later, use the syntax `liquibase.command.defaultSchemaName`. Note: In Liquibase 4.12.0 and later, you can use mixed-case schema names if you set `--preserve-schema-case` to `true`. However, in Liquibase 4.12.0–4.22.0, the Liquibase validator still throws a `DatabaseException` error if you specify a mixed-case value of `defaultSchemaName`. In 4.23.0 and later, the Liquibase validator accepts any casing.	Optional
`--driver=<string>`	The JDBC driver class	Optional
`--driver-properties-file=<string>`	The JDBC driver properties file	Optional
`--label-filter=<string>`	Specifies the changeset labels to match. Labels are tags you can add to changesets to control which changesets will be executed in any migration run.	Optional
`--output-default-catalog=<true\|false>`	Control whether names of objects in the default catalog are fully qualified or not. If `true`, they are. If `false`, only objects outside the default catalog are fully qualified. Default: `true`.	Optional
`--output-default-schema=<true\|false>`	Control whether names of objects in the default schema are fully qualified or not. If `true`, they are. If `false`, only objects outside the default schema are fully qualified. Default: `true`.	Optional
`--password=<string>`	Password to connect to the target database.	Optional
`--rollback-script=<string>`	The path to the script to use to perform the rollback. Only needed if the rollback is not already defined in the changelog, and if it is not a rollback statement that Liquibase automatically generates.	Optional
`--username=<string>`	Username to connect to the target database.	Optional

Global parameters

Attribute	Definition	Requirement
`globalArgs: { output-file: "<string>" }`	File path to where the command output will be written. If not specified, output goes to `STDOUT`. See `--output-file`.	Optional

Command parameters

Attribute	Definition	Requirement
`cmdArgs: { changelog-file: "<string>" }`	The root changelog	Required
`cmdArgs: { date: "<string>" }`	The date and time your database rolls back to. The date format is `YYYY-MM-DD HH:MM:SS` or `YYYY-MM-DD'T'HH:MM:SS`. However, it is possible to indicate the date or time only. Specify as `--date=myDate`. Positional format `<command> <date>` deprecated in 4.4+.	Required
`cmdArgs: { url: "<string>" }`	The JDBC database connection URL.	Required
`cmdArgs: { change-exec-listener-class: "<string>" }`	Fully-qualified class that specifies a `ChangeExecListener`.	Optional
`cmdArgs: { change-exec-listener-properties-file: "<string>" }`	Path to a properties file for the `ChangeExecListener` class.	Optional
`cmdArgs: { context-filter: "<string>" }`	Specifies the changeset contexts to match. Contexts are tags you can add to changesets to control which changesets are executed in any particular migration run. Note: If you use Liquibase 4.23.0 or earlier, use the syntax `--contexts` instead of `--context-filter`.	Optional
`cmdArgs: { default-catalog-name: "<string>" }`	Name of the default catalog to use for the database connection	Optional
`cmdArgs: { default-schema-name: "<string>" }`	Name of the default schema to use for the database connection. If `defaultSchemaName` is set, then objects do not have to be fully qualified. This means you can refer to just `mytable` instead of `myschema.mytable`. Note: In the properties file and `JAVA_OPTS` only: in 4.18.0 and earlier, specify this parameter using the syntax `defaultSchemaName`. In 4.19.0 and later, use the syntax `liquibase.command.defaultSchemaName`. Note: In Liquibase 4.12.0 and later, you can use mixed-case schema names if you set `--preserve-schema-case` to `true`. However, in Liquibase 4.12.0–4.22.0, the Liquibase validator still throws a `DatabaseException` error if you specify a mixed-case value of `defaultSchemaName`. In 4.23.0 and later, the Liquibase validator accepts any casing.	Optional
`cmdArgs: { driver: "<string>" }`	The JDBC driver class	Optional
`cmdArgs: { driver-properties-file: "<string>" }`	The JDBC driver properties file	Optional
`cmdArgs: { label-filter: "<string>" }`	Specifies the changeset labels to match. Labels are tags you can add to changesets to control which changesets will be executed in any migration run.	Optional
`cmdArgs: { output-default-catalog: "<true\|false>" }`	Control whether names of objects in the default catalog are fully qualified or not. If `true`, they are. If `false`, only objects outside the default catalog are fully qualified. Default: `true`.	Optional
`cmdArgs: { output-default-schema: "<true\|false>" }`	Control whether names of objects in the default schema are fully qualified or not. If `true`, they are. If `false`, only objects outside the default schema are fully qualified. Default: `true`.	Optional
`cmdArgs: { password: "<string>" }`	Password to connect to the target database.	Optional
`cmdArgs: { rollback-script: "<string>" }`	The path to the script to use to perform the rollback. Only needed if the rollback is not already defined in the changelog, and if it is not a rollback statement that Liquibase automatically generates.	Optional
`cmdArgs: { username: "<string>" }`	Username to connect to the target database.	Optional

Global parameters

Attribute	Definition	Requirement
`liquibase.outputFile: <string>`	File path to where the command output will be written. If not specified, output goes to `STDOUT`. See `--output-file`.	Optional

Command parameters

Attribute	Definition	Requirement
`liquibase.command.changelogFile: <string>` `liquibase.command.rollbackToDateSql.changelogFile: <string>`	The root changelog	Required
`liquibase.command.date: <string>` `liquibase.command.rollbackToDateSql.date: <string>`	The date and time your database rolls back to. The date format is `YYYY-MM-DD HH:MM:SS` or `YYYY-MM-DD'T'HH:MM:SS`. However, it is possible to indicate the date or time only. Specify as `--date=myDate`. Positional format `<command> <date>` deprecated in 4.4+.	Required
`liquibase.command.url: <string>` `liquibase.command.rollbackToDateSql.url: <string>`	The JDBC database connection URL.	Required
`liquibase.command.changeExecListenerClass: <string>` `liquibase.command.rollbackToDateSql.changeExecListenerClass: <string>`	Fully-qualified class that specifies a `ChangeExecListener`.	Optional
`liquibase.command.changeExecListenerPropertiesFile: <string>` `liquibase.command.rollbackToDateSql.changeExecListenerPropertiesFile: <string>`	Path to a properties file for the `ChangeExecListener` class.	Optional
`liquibase.command.contextFilter: <string>` `liquibase.command.rollbackToDateSql.contextFilter: <string>`	Specifies the changeset contexts to match. Contexts are tags you can add to changesets to control which changesets are executed in any particular migration run. Note: If you use Liquibase 4.23.0 or earlier, use the syntax `--contexts` instead of `--context-filter`.	Optional
`liquibase.command.defaultCatalogName: <string>` `liquibase.command.rollbackToDateSql.defaultCatalogName: <string>`	Name of the default catalog to use for the database connection	Optional
`liquibase.command.defaultSchemaName: <string>` `liquibase.command.rollbackToDateSql.defaultSchemaName: <string>`	Name of the default schema to use for the database connection. If `defaultSchemaName` is set, then objects do not have to be fully qualified. This means you can refer to just `mytable` instead of `myschema.mytable`. Note: In the properties file and `JAVA_OPTS` only: in 4.18.0 and earlier, specify this parameter using the syntax `defaultSchemaName`. In 4.19.0 and later, use the syntax `liquibase.command.defaultSchemaName`. Note: In Liquibase 4.12.0 and later, you can use mixed-case schema names if you set `--preserve-schema-case` to `true`. However, in Liquibase 4.12.0–4.22.0, the Liquibase validator still throws a `DatabaseException` error if you specify a mixed-case value of `defaultSchemaName`. In 4.23.0 and later, the Liquibase validator accepts any casing.	Optional
`liquibase.command.driver: <string>` `liquibase.command.rollbackToDateSql.driver: <string>`	The JDBC driver class	Optional
`liquibase.command.driverPropertiesFile: <string>` `liquibase.command.rollbackToDateSql.driverPropertiesFile: <string>`	The JDBC driver properties file	Optional
`liquibase.command.labelFilter: <string>` `liquibase.command.rollbackToDateSql.labelFilter: <string>`	Specifies the changeset labels to match. Labels are tags you can add to changesets to control which changesets will be executed in any migration run.	Optional
`liquibase.command.outputDefaultCatalog: <true\|false>` `liquibase.command.rollbackToDateSql.outputDefaultCatalog: <true\|false>`	Control whether names of objects in the default catalog are fully qualified or not. If `true`, they are. If `false`, only objects outside the default catalog are fully qualified. Default: `true`.	Optional
`liquibase.command.outputDefaultSchema: <true\|false>` `liquibase.command.rollbackToDateSql.outputDefaultSchema: <true\|false>`	Control whether names of objects in the default schema are fully qualified or not. If `true`, they are. If `false`, only objects outside the default schema are fully qualified. Default: `true`.	Optional
`liquibase.command.password: <string>` `liquibase.command.rollbackToDateSql.password: <string>`	Password to connect to the target database.	Optional
`liquibase.command.rollbackScript: <string>` `liquibase.command.rollbackToDateSql.rollbackScript: <string>`	The path to the script to use to perform the rollback. Only needed if the rollback is not already defined in the changelog, and if it is not a rollback statement that Liquibase automatically generates.	Optional
`liquibase.command.username: <string>` `liquibase.command.rollbackToDateSql.username: <string>`	Username to connect to the target database.	Optional

Global parameters

Attribute	Definition	Requirement
`JAVA_OPTS=-Dliquibase.outputFile=<string>`	File path to where the command output will be written. If not specified, output goes to `STDOUT`. See `--output-file`.	Optional

Command parameters

Attribute	Definition	Requirement
`JAVA_OPTS=-Dliquibase.command.changelogFile=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.changelogFile=<string>`	The root changelog	Required
`JAVA_OPTS=-Dliquibase.command.date=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.date=<string>`	The date and time your database rolls back to. The date format is `YYYY-MM-DD HH:MM:SS` or `YYYY-MM-DD'T'HH:MM:SS`. However, it is possible to indicate the date or time only. Specify as `--date=myDate`. Positional format `<command> <date>` deprecated in 4.4+.	Required
`JAVA_OPTS=-Dliquibase.command.url=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.url=<string>`	The JDBC database connection URL.	Required
`JAVA_OPTS=-Dliquibase.command.changeExecListenerClass=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.changeExecListenerClass=<string>`	Fully-qualified class that specifies a `ChangeExecListener`.	Optional
`JAVA_OPTS=-Dliquibase.command.changeExecListenerPropertiesFile=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.changeExecListenerPropertiesFile=<string>`	Path to a properties file for the `ChangeExecListener` class.	Optional
`JAVA_OPTS=-Dliquibase.command.contextFilter=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.contextFilter=<string>`	Specifies the changeset contexts to match. Contexts are tags you can add to changesets to control which changesets are executed in any particular migration run. Note: If you use Liquibase 4.23.0 or earlier, use the syntax `--contexts` instead of `--context-filter`.	Optional
`JAVA_OPTS=-Dliquibase.command.defaultCatalogName=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.defaultCatalogName=<string>`	Name of the default catalog to use for the database connection	Optional
`JAVA_OPTS=-Dliquibase.command.defaultSchemaName=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.defaultSchemaName=<string>`	Name of the default schema to use for the database connection. If `defaultSchemaName` is set, then objects do not have to be fully qualified. This means you can refer to just `mytable` instead of `myschema.mytable`. Note: In the properties file and `JAVA_OPTS` only: in 4.18.0 and earlier, specify this parameter using the syntax `defaultSchemaName`. In 4.19.0 and later, use the syntax `liquibase.command.defaultSchemaName`. Note: In Liquibase 4.12.0 and later, you can use mixed-case schema names if you set `--preserve-schema-case` to `true`. However, in Liquibase 4.12.0–4.22.0, the Liquibase validator still throws a `DatabaseException` error if you specify a mixed-case value of `defaultSchemaName`. In 4.23.0 and later, the Liquibase validator accepts any casing.	Optional
`JAVA_OPTS=-Dliquibase.command.driver=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.driver=<string>`	The JDBC driver class	Optional
`JAVA_OPTS=-Dliquibase.command.driverPropertiesFile=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.driverPropertiesFile=<string>`	The JDBC driver properties file	Optional
`JAVA_OPTS=-Dliquibase.command.labelFilter=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.labelFilter=<string>`	Specifies the changeset labels to match. Labels are tags you can add to changesets to control which changesets will be executed in any migration run.	Optional
`JAVA_OPTS=-Dliquibase.command.outputDefaultCatalog=<true\|false>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.outputDefaultCatalog=<true\|false>`	Control whether names of objects in the default catalog are fully qualified or not. If `true`, they are. If `false`, only objects outside the default catalog are fully qualified. Default: `true`.	Optional
`JAVA_OPTS=-Dliquibase.command.outputDefaultSchema=<true\|false>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.outputDefaultSchema=<true\|false>`	Control whether names of objects in the default schema are fully qualified or not. If `true`, they are. If `false`, only objects outside the default schema are fully qualified. Default: `true`.	Optional
`JAVA_OPTS=-Dliquibase.command.password=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.password=<string>`	Password to connect to the target database.	Optional
`JAVA_OPTS=-Dliquibase.command.rollbackScript=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.rollbackScript=<string>`	The path to the script to use to perform the rollback. Only needed if the rollback is not already defined in the changelog, and if it is not a rollback statement that Liquibase automatically generates.	Optional
`JAVA_OPTS=-Dliquibase.command.username=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.username=<string>`	Username to connect to the target database.	Optional

Global parameters

Attribute	Definition	Requirement
`LIQUIBASE_OUTPUT_FILE=<string>`	File path to where the command output will be written. If not specified, output goes to `STDOUT`. See `--output-file`.	Optional

Command parameters

Attribute	Definition	Requirement
`LIQUIBASE_COMMAND_CHANGELOG_FILE=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_CHANGELOG_FILE=<string>`	The root changelog	Required
`LIQUIBASE_COMMAND_DATE=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_DATE=<string>`	The date and time your database rolls back to. The date format is `YYYY-MM-DD HH:MM:SS` or `YYYY-MM-DD'T'HH:MM:SS`. However, it is possible to indicate the date or time only. Specify as `--date=myDate`. Positional format `<command> <date>` deprecated in 4.4+.	Required
`LIQUIBASE_COMMAND_URL=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_URL=<string>`	The JDBC database connection URL.	Required
`LIQUIBASE_COMMAND_CHANGE_EXEC_LISTENER_CLASS=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_CHANGE_EXEC_LISTENER_CLASS=<string>`	Fully-qualified class that specifies a `ChangeExecListener`.	Optional
`LIQUIBASE_COMMAND_CHANGE_EXEC_LISTENER_PROPERTIES_FILE=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_CHANGE_EXEC_LISTENER_PROPERTIES_FILE=<string>`	Path to a properties file for the `ChangeExecListener` class.	Optional
`LIQUIBASE_COMMAND_CONTEXT_FILTER=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_CONTEXT_FILTER=<string>`	Specifies the changeset contexts to match. Contexts are tags you can add to changesets to control which changesets are executed in any particular migration run. Note: If you use Liquibase 4.23.0 or earlier, use the syntax `--contexts` instead of `--context-filter`.	Optional
`LIQUIBASE_COMMAND_DEFAULT_CATALOG_NAME=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_DEFAULT_CATALOG_NAME=<string>`	Name of the default catalog to use for the database connection	Optional
`LIQUIBASE_COMMAND_DEFAULT_SCHEMA_NAME=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_DEFAULT_SCHEMA_NAME=<string>`	Name of the default schema to use for the database connection. If `defaultSchemaName` is set, then objects do not have to be fully qualified. This means you can refer to just `mytable` instead of `myschema.mytable`. Note: In the properties file and `JAVA_OPTS` only: in 4.18.0 and earlier, specify this parameter using the syntax `defaultSchemaName`. In 4.19.0 and later, use the syntax `liquibase.command.defaultSchemaName`. Note: In Liquibase 4.12.0 and later, you can use mixed-case schema names if you set `--preserve-schema-case` to `true`. However, in Liquibase 4.12.0–4.22.0, the Liquibase validator still throws a `DatabaseException` error if you specify a mixed-case value of `defaultSchemaName`. In 4.23.0 and later, the Liquibase validator accepts any casing.	Optional
`LIQUIBASE_COMMAND_DRIVER=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_DRIVER=<string>`	The JDBC driver class	Optional
`LIQUIBASE_COMMAND_DRIVER_PROPERTIES_FILE=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_DRIVER_PROPERTIES_FILE=<string>`	The JDBC driver properties file	Optional
`LIQUIBASE_COMMAND_LABEL_FILTER=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_LABEL_FILTER=<string>`	Specifies the changeset labels to match. Labels are tags you can add to changesets to control which changesets will be executed in any migration run.	Optional
`LIQUIBASE_COMMAND_OUTPUT_DEFAULT_CATALOG=<true\|false>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_OUTPUT_DEFAULT_CATALOG=<true\|false>`	Control whether names of objects in the default catalog are fully qualified or not. If `true`, they are. If `false`, only objects outside the default catalog are fully qualified. Default: `true`.	Optional
`LIQUIBASE_COMMAND_OUTPUT_DEFAULT_SCHEMA=<true\|false>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_OUTPUT_DEFAULT_SCHEMA=<true\|false>`	Control whether names of objects in the default schema are fully qualified or not. If `true`, they are. If `false`, only objects outside the default schema are fully qualified. Default: `true`.	Optional
`LIQUIBASE_COMMAND_PASSWORD=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_PASSWORD=<string>`	Password to connect to the target database.	Optional
`LIQUIBASE_COMMAND_ROLLBACK_SCRIPT=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_ROLLBACK_SCRIPT=<string>`	The path to the script to use to perform the rollback. Only needed if the rollback is not already defined in the changelog, and if it is not a rollback statement that Liquibase automatically generates.	Optional
`LIQUIBASE_COMMAND_USERNAME=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_USERNAME=<string>`	Username to connect to the target database.	Optional

Global parameters

Attribute	Definition	Requirement
`--output-file=<string>`	File path to where the command output will be written. If not specified, output goes to `STDOUT`. See `--output-file`.	Optional

Command parameters

Attribute	Definition	Requirement
`--changelog-file=<string>`	The root changelog	Required
`--date=<string>`	The date and time your database rolls back to. The date format is `YYYY-MM-DD HH:MM:SS` or `YYYY-MM-DD'T'HH:MM:SS`. However, it is possible to indicate the date or time only. Specify as `--date=myDate`. Positional format `<command> <date>` deprecated in 4.4+.	Required
`--url=<string>`	The JDBC database connection URL.	Required
`--change-exec-listener-class=<string>`	Fully-qualified class that specifies a `ChangeExecListener`.	Optional
`--change-exec-listener-properties-file=<string>`	Path to a properties file for the `ChangeExecListener` class.	Optional
`--context-filter=<string>`	Specifies the changeset contexts to match. Contexts are tags you can add to changesets to control which changesets are executed in any particular migration run. Note: If you use Liquibase 4.23.0 or earlier, use the syntax `--contexts` instead of `--context-filter`.	Optional
`--default-catalog-name=<string>`	Name of the default catalog to use for the database connection	Optional
`--default-schema-name=<string>`	Name of the default schema to use for the database connection. If `defaultSchemaName` is set, then objects do not have to be fully qualified. This means you can refer to just `mytable` instead of `myschema.mytable`. Note: In the properties file and `JAVA_OPTS` only: in 4.18.0 and earlier, specify this parameter using the syntax `defaultSchemaName`. In 4.19.0 and later, use the syntax `liquibase.command.defaultSchemaName`. Note: In Liquibase 4.12.0 and later, you can use mixed-case schema names if you set `--preserve-schema-case` to `true`. However, in Liquibase 4.12.0–4.22.0, the Liquibase validator still throws a `DatabaseException` error if you specify a mixed-case value of `defaultSchemaName`. In 4.23.0 and later, the Liquibase validator accepts any casing.	Optional
`--driver=<string>`	The JDBC driver class	Optional
`--driver-properties-file=<string>`	The JDBC driver properties file	Optional
`--label-filter=<string>`	Specifies the changeset labels to match. Labels are tags you can add to changesets to control which changesets will be executed in any migration run.	Optional
`--output-default-catalog=<true\|false>`	Control whether names of objects in the default catalog are fully qualified or not. If `true`, they are. If `false`, only objects outside the default catalog are fully qualified. Default: `true`.	Optional
`--output-default-schema=<true\|false>`	Control whether names of objects in the default schema are fully qualified or not. If `true`, they are. If `false`, only objects outside the default schema are fully qualified. Default: `true`.	Optional
`--password=<string>`	Password to connect to the target database.	Optional
`--rollback-script=<string>`	The path to the script to use to perform the rollback. Only needed if the rollback is not already defined in the changelog, and if it is not a rollback statement that Liquibase automatically generates.	Optional
`--username=<string>`	Username to connect to the target database.	Optional

Global parameters

Attribute	Definition	Requirement
`globalArgs: { output-file: "<string>" }`	File path to where the command output will be written. If not specified, output goes to `STDOUT`. See `--output-file`.	Optional

Command parameters

Attribute	Definition	Requirement
`cmdArgs: { changelog-file: "<string>" }`	The root changelog	Required
`cmdArgs: { date: "<string>" }`	The date and time your database rolls back to. The date format is `YYYY-MM-DD HH:MM:SS` or `YYYY-MM-DD'T'HH:MM:SS`. However, it is possible to indicate the date or time only. Specify as `--date=myDate`. Positional format `<command> <date>` deprecated in 4.4+.	Required
`cmdArgs: { url: "<string>" }`	The JDBC database connection URL.	Required
`cmdArgs: { change-exec-listener-class: "<string>" }`	Fully-qualified class that specifies a `ChangeExecListener`.	Optional
`cmdArgs: { change-exec-listener-properties-file: "<string>" }`	Path to a properties file for the `ChangeExecListener` class.	Optional
`cmdArgs: { context-filter: "<string>" }`	Specifies the changeset contexts to match. Contexts are tags you can add to changesets to control which changesets are executed in any particular migration run. Note: If you use Liquibase 4.23.0 or earlier, use the syntax `--contexts` instead of `--context-filter`.	Optional
`cmdArgs: { default-catalog-name: "<string>" }`	Name of the default catalog to use for the database connection	Optional
`cmdArgs: { default-schema-name: "<string>" }`	Name of the default schema to use for the database connection. If `defaultSchemaName` is set, then objects do not have to be fully qualified. This means you can refer to just `mytable` instead of `myschema.mytable`. Note: In the properties file and `JAVA_OPTS` only: in 4.18.0 and earlier, specify this parameter using the syntax `defaultSchemaName`. In 4.19.0 and later, use the syntax `liquibase.command.defaultSchemaName`. Note: In Liquibase 4.12.0 and later, you can use mixed-case schema names if you set `--preserve-schema-case` to `true`. However, in Liquibase 4.12.0–4.22.0, the Liquibase validator still throws a `DatabaseException` error if you specify a mixed-case value of `defaultSchemaName`. In 4.23.0 and later, the Liquibase validator accepts any casing.	Optional
`cmdArgs: { driver: "<string>" }`	The JDBC driver class	Optional
`cmdArgs: { driver-properties-file: "<string>" }`	The JDBC driver properties file	Optional
`cmdArgs: { label-filter: "<string>" }`	Specifies the changeset labels to match. Labels are tags you can add to changesets to control which changesets will be executed in any migration run.	Optional
`cmdArgs: { output-default-catalog: "<true\|false>" }`	Control whether names of objects in the default catalog are fully qualified or not. If `true`, they are. If `false`, only objects outside the default catalog are fully qualified. Default: `true`.	Optional
`cmdArgs: { output-default-schema: "<true\|false>" }`	Control whether names of objects in the default schema are fully qualified or not. If `true`, they are. If `false`, only objects outside the default schema are fully qualified. Default: `true`.	Optional
`cmdArgs: { password: "<string>" }`	Password to connect to the target database.	Optional
`cmdArgs: { rollback-script: "<string>" }`	The path to the script to use to perform the rollback. Only needed if the rollback is not already defined in the changelog, and if it is not a rollback statement that Liquibase automatically generates.	Optional
`cmdArgs: { username: "<string>" }`	Username to connect to the target database.	Optional

Global parameters

Attribute	Definition	Requirement
`liquibase.outputFile: <string>`	File path to where the command output will be written. If not specified, output goes to `STDOUT`. See `--output-file`.	Optional

Command parameters

Attribute	Definition	Requirement
`liquibase.command.changelogFile: <string>` `liquibase.command.rollbackToDateSql.changelogFile: <string>`	The root changelog	Required
`liquibase.command.date: <string>` `liquibase.command.rollbackToDateSql.date: <string>`	The date and time your database rolls back to. The date format is `YYYY-MM-DD HH:MM:SS` or `YYYY-MM-DD'T'HH:MM:SS`. However, it is possible to indicate the date or time only. Specify as `--date=myDate`. Positional format `<command> <date>` deprecated in 4.4+.	Required
`liquibase.command.url: <string>` `liquibase.command.rollbackToDateSql.url: <string>`	The JDBC database connection URL.	Required
`liquibase.command.changeExecListenerClass: <string>` `liquibase.command.rollbackToDateSql.changeExecListenerClass: <string>`	Fully-qualified class that specifies a `ChangeExecListener`.	Optional
`liquibase.command.changeExecListenerPropertiesFile: <string>` `liquibase.command.rollbackToDateSql.changeExecListenerPropertiesFile: <string>`	Path to a properties file for the `ChangeExecListener` class.	Optional
`liquibase.command.contextFilter: <string>` `liquibase.command.rollbackToDateSql.contextFilter: <string>`	Specifies the changeset contexts to match. Contexts are tags you can add to changesets to control which changesets are executed in any particular migration run. Note: If you use Liquibase 4.23.0 or earlier, use the syntax `--contexts` instead of `--context-filter`.	Optional
`liquibase.command.defaultCatalogName: <string>` `liquibase.command.rollbackToDateSql.defaultCatalogName: <string>`	Name of the default catalog to use for the database connection	Optional
`liquibase.command.defaultSchemaName: <string>` `liquibase.command.rollbackToDateSql.defaultSchemaName: <string>`	Name of the default schema to use for the database connection. If `defaultSchemaName` is set, then objects do not have to be fully qualified. This means you can refer to just `mytable` instead of `myschema.mytable`. Note: In the properties file and `JAVA_OPTS` only: in 4.18.0 and earlier, specify this parameter using the syntax `defaultSchemaName`. In 4.19.0 and later, use the syntax `liquibase.command.defaultSchemaName`. Note: In Liquibase 4.12.0 and later, you can use mixed-case schema names if you set `--preserve-schema-case` to `true`. However, in Liquibase 4.12.0–4.22.0, the Liquibase validator still throws a `DatabaseException` error if you specify a mixed-case value of `defaultSchemaName`. In 4.23.0 and later, the Liquibase validator accepts any casing.	Optional
`liquibase.command.driver: <string>` `liquibase.command.rollbackToDateSql.driver: <string>`	The JDBC driver class	Optional
`liquibase.command.driverPropertiesFile: <string>` `liquibase.command.rollbackToDateSql.driverPropertiesFile: <string>`	The JDBC driver properties file	Optional
`liquibase.command.labelFilter: <string>` `liquibase.command.rollbackToDateSql.labelFilter: <string>`	Specifies the changeset labels to match. Labels are tags you can add to changesets to control which changesets will be executed in any migration run.	Optional
`liquibase.command.outputDefaultCatalog: <true\|false>` `liquibase.command.rollbackToDateSql.outputDefaultCatalog: <true\|false>`	Control whether names of objects in the default catalog are fully qualified or not. If `true`, they are. If `false`, only objects outside the default catalog are fully qualified. Default: `true`.	Optional
`liquibase.command.outputDefaultSchema: <true\|false>` `liquibase.command.rollbackToDateSql.outputDefaultSchema: <true\|false>`	Control whether names of objects in the default schema are fully qualified or not. If `true`, they are. If `false`, only objects outside the default schema are fully qualified. Default: `true`.	Optional
`liquibase.command.password: <string>` `liquibase.command.rollbackToDateSql.password: <string>`	Password to connect to the target database.	Optional
`liquibase.command.rollbackScript: <string>` `liquibase.command.rollbackToDateSql.rollbackScript: <string>`	The path to the script to use to perform the rollback. Only needed if the rollback is not already defined in the changelog, and if it is not a rollback statement that Liquibase automatically generates.	Optional
`liquibase.command.username: <string>` `liquibase.command.rollbackToDateSql.username: <string>`	Username to connect to the target database.	Optional

Global parameters

Attribute	Definition	Requirement
`JAVA_OPTS=-Dliquibase.outputFile=<string>`	File path to where the command output will be written. If not specified, output goes to `STDOUT`. See `--output-file`.	Optional

Command parameters

Attribute	Definition	Requirement
`JAVA_OPTS=-Dliquibase.command.changelogFile=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.changelogFile=<string>`	The root changelog	Required
`JAVA_OPTS=-Dliquibase.command.date=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.date=<string>`	The date and time your database rolls back to. The date format is `YYYY-MM-DD HH:MM:SS` or `YYYY-MM-DD'T'HH:MM:SS`. However, it is possible to indicate the date or time only. Specify as `--date=myDate`. Positional format `<command> <date>` deprecated in 4.4+.	Required
`JAVA_OPTS=-Dliquibase.command.url=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.url=<string>`	The JDBC database connection URL.	Required
`JAVA_OPTS=-Dliquibase.command.changeExecListenerClass=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.changeExecListenerClass=<string>`	Fully-qualified class that specifies a `ChangeExecListener`.	Optional
`JAVA_OPTS=-Dliquibase.command.changeExecListenerPropertiesFile=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.changeExecListenerPropertiesFile=<string>`	Path to a properties file for the `ChangeExecListener` class.	Optional
`JAVA_OPTS=-Dliquibase.command.contextFilter=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.contextFilter=<string>`	Specifies the changeset contexts to match. Contexts are tags you can add to changesets to control which changesets are executed in any particular migration run. Note: If you use Liquibase 4.23.0 or earlier, use the syntax `--contexts` instead of `--context-filter`.	Optional
`JAVA_OPTS=-Dliquibase.command.defaultCatalogName=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.defaultCatalogName=<string>`	Name of the default catalog to use for the database connection	Optional
`JAVA_OPTS=-Dliquibase.command.defaultSchemaName=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.defaultSchemaName=<string>`	Name of the default schema to use for the database connection. If `defaultSchemaName` is set, then objects do not have to be fully qualified. This means you can refer to just `mytable` instead of `myschema.mytable`. Note: In the properties file and `JAVA_OPTS` only: in 4.18.0 and earlier, specify this parameter using the syntax `defaultSchemaName`. In 4.19.0 and later, use the syntax `liquibase.command.defaultSchemaName`. Note: In Liquibase 4.12.0 and later, you can use mixed-case schema names if you set `--preserve-schema-case` to `true`. However, in Liquibase 4.12.0–4.22.0, the Liquibase validator still throws a `DatabaseException` error if you specify a mixed-case value of `defaultSchemaName`. In 4.23.0 and later, the Liquibase validator accepts any casing.	Optional
`JAVA_OPTS=-Dliquibase.command.driver=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.driver=<string>`	The JDBC driver class	Optional
`JAVA_OPTS=-Dliquibase.command.driverPropertiesFile=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.driverPropertiesFile=<string>`	The JDBC driver properties file	Optional
`JAVA_OPTS=-Dliquibase.command.labelFilter=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.labelFilter=<string>`	Specifies the changeset labels to match. Labels are tags you can add to changesets to control which changesets will be executed in any migration run.	Optional
`JAVA_OPTS=-Dliquibase.command.outputDefaultCatalog=<true\|false>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.outputDefaultCatalog=<true\|false>`	Control whether names of objects in the default catalog are fully qualified or not. If `true`, they are. If `false`, only objects outside the default catalog are fully qualified. Default: `true`.	Optional
`JAVA_OPTS=-Dliquibase.command.outputDefaultSchema=<true\|false>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.outputDefaultSchema=<true\|false>`	Control whether names of objects in the default schema are fully qualified or not. If `true`, they are. If `false`, only objects outside the default schema are fully qualified. Default: `true`.	Optional
`JAVA_OPTS=-Dliquibase.command.password=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.password=<string>`	Password to connect to the target database.	Optional
`JAVA_OPTS=-Dliquibase.command.rollbackScript=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.rollbackScript=<string>`	The path to the script to use to perform the rollback. Only needed if the rollback is not already defined in the changelog, and if it is not a rollback statement that Liquibase automatically generates.	Optional
`JAVA_OPTS=-Dliquibase.command.username=<string>` `JAVA_OPTS=-Dliquibase.command.rollbackToDateSql.username=<string>`	Username to connect to the target database.	Optional

Global parameters

Attribute	Definition	Requirement
`LIQUIBASE_OUTPUT_FILE=<string>`	File path to where the command output will be written. If not specified, output goes to `STDOUT`. See `--output-file`.	Optional

Command parameters

Attribute	Definition	Requirement
`LIQUIBASE_COMMAND_CHANGELOG_FILE=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_CHANGELOG_FILE=<string>`	The root changelog	Required
`LIQUIBASE_COMMAND_DATE=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_DATE=<string>`	The date and time your database rolls back to. The date format is `YYYY-MM-DD HH:MM:SS` or `YYYY-MM-DD'T'HH:MM:SS`. However, it is possible to indicate the date or time only. Specify as `--date=myDate`. Positional format `<command> <date>` deprecated in 4.4+.	Required
`LIQUIBASE_COMMAND_URL=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_URL=<string>`	The JDBC database connection URL.	Required
`LIQUIBASE_COMMAND_CHANGE_EXEC_LISTENER_CLASS=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_CHANGE_EXEC_LISTENER_CLASS=<string>`	Fully-qualified class that specifies a `ChangeExecListener`.	Optional
`LIQUIBASE_COMMAND_CHANGE_EXEC_LISTENER_PROPERTIES_FILE=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_CHANGE_EXEC_LISTENER_PROPERTIES_FILE=<string>`	Path to a properties file for the `ChangeExecListener` class.	Optional
`LIQUIBASE_COMMAND_CONTEXT_FILTER=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_CONTEXT_FILTER=<string>`	Specifies the changeset contexts to match. Contexts are tags you can add to changesets to control which changesets are executed in any particular migration run. Note: If you use Liquibase 4.23.0 or earlier, use the syntax `--contexts` instead of `--context-filter`.	Optional
`LIQUIBASE_COMMAND_DEFAULT_CATALOG_NAME=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_DEFAULT_CATALOG_NAME=<string>`	Name of the default catalog to use for the database connection	Optional
`LIQUIBASE_COMMAND_DEFAULT_SCHEMA_NAME=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_DEFAULT_SCHEMA_NAME=<string>`	Name of the default schema to use for the database connection. If `defaultSchemaName` is set, then objects do not have to be fully qualified. This means you can refer to just `mytable` instead of `myschema.mytable`. Note: In the properties file and `JAVA_OPTS` only: in 4.18.0 and earlier, specify this parameter using the syntax `defaultSchemaName`. In 4.19.0 and later, use the syntax `liquibase.command.defaultSchemaName`. Note: In Liquibase 4.12.0 and later, you can use mixed-case schema names if you set `--preserve-schema-case` to `true`. However, in Liquibase 4.12.0–4.22.0, the Liquibase validator still throws a `DatabaseException` error if you specify a mixed-case value of `defaultSchemaName`. In 4.23.0 and later, the Liquibase validator accepts any casing.	Optional
`LIQUIBASE_COMMAND_DRIVER=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_DRIVER=<string>`	The JDBC driver class	Optional
`LIQUIBASE_COMMAND_DRIVER_PROPERTIES_FILE=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_DRIVER_PROPERTIES_FILE=<string>`	The JDBC driver properties file	Optional
`LIQUIBASE_COMMAND_LABEL_FILTER=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_LABEL_FILTER=<string>`	Specifies the changeset labels to match. Labels are tags you can add to changesets to control which changesets will be executed in any migration run.	Optional
`LIQUIBASE_COMMAND_OUTPUT_DEFAULT_CATALOG=<true\|false>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_OUTPUT_DEFAULT_CATALOG=<true\|false>`	Control whether names of objects in the default catalog are fully qualified or not. If `true`, they are. If `false`, only objects outside the default catalog are fully qualified. Default: `true`.	Optional
`LIQUIBASE_COMMAND_OUTPUT_DEFAULT_SCHEMA=<true\|false>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_OUTPUT_DEFAULT_SCHEMA=<true\|false>`	Control whether names of objects in the default schema are fully qualified or not. If `true`, they are. If `false`, only objects outside the default schema are fully qualified. Default: `true`.	Optional
`LIQUIBASE_COMMAND_PASSWORD=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_PASSWORD=<string>`	Password to connect to the target database.	Optional
`LIQUIBASE_COMMAND_ROLLBACK_SCRIPT=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_ROLLBACK_SCRIPT=<string>`	The path to the script to use to perform the rollback. Only needed if the rollback is not already defined in the changelog, and if it is not a rollback statement that Liquibase automatically generates.	Optional
`LIQUIBASE_COMMAND_USERNAME=<string>` `LIQUIBASE_COMMAND_ROLLBACK_TO_DATE_SQL_USERNAME=<string>`	Username to connect to the target database.	Optional

Output

Liquibase Community 4.9.1 by Liquibase -- ********************************************************************* --rollback to 2022-05-04 Script -- ********************************************************************* -- Change Log: example-changelog.sql -- Ran at: 5/6/22, 1:16 PM -- Against: DBUSER@jdbc:h2:tcp://localhost:9090/mem:dev -- Liquibase version: 4.9.1 -- ********************************************************************* -- Lock Database UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'DESKTOP-SQVSSV2 (192.168.1.179)', LOCKGRANTED = NOW() WHERE ID = 1 AND LOCKED = FALSE; -- Rolling Back ChangeSet: example-changelog.sql::3::other.dev ALTER TABLE person DROP COLUMN country; DELETE FROM PUBLIC.DATABASECHANGELOG WHERE ID = '3' AND AUTHOR = 'other.dev' AND FILENAME = 'example-changelog.sql'; -- Rolling Back ChangeSet: example-changelog.sql::2::your.name DROP TABLE company; DELETE FROM PUBLIC.DATABASECHANGELOG WHERE ID = '2' AND AUTHOR = 'your.name' AND FILENAME = 'example-changelog.sql'; -- Rolling Back ChangeSet: example-changelog.sql::1::your.name DROP TABLE person; DELETE FROM PUBLIC.DATABASECHANGELOG WHERE ID = '1' AND AUTHOR = 'your.name' AND FILENAME = 'example-changelog.sql'; -- Release Database Lock UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1; Liquibase command 'rollback-to-date-sql' was executed successfully.