futureRollbackCountSQL <value> command

The futureRollbackCountSQL <value> command generates the SQL that Liquibase would use to sequentially revert the number of changes associated with undeployed changesets, which are added to a changelog file.


The futureRollbackCountSQL <value> command is typically used to inspect the SQL before rolling back the number of changesets that you have not deployed to your database but added to your changelog. The command shows the output starting with the most recent changes until the value specified is reached.

It is best practice to inspect SQL, which Liquibase would run when using the rollback command so you can review any changes the command would make to your database.

Running the futureRollbackCountSQL <value> command

To run the futureRollbackCountSQL <value> command, you can specify the driver, classpath, and URL in your liquibase.properties file. For more information, see Creating and configuring a liquibase.properties file. You can also specify these properties in your command line.

Then run the futureRollbackCountSQL <value> command:

liquibase --changeLogFile=dbchangelog.xml futureRollbackCountSQL 2

Note: Enter the name of the changelog and the number of changesets you want to use in place of dbchangelog.xml and 2.

futureRollbackCountSQL <value> global attributes

Attribute Definition Requirement
--changeLogFile The root changelog Required
--url The JDBC database connection URL Required
--username The database username Required
--password The database password Required
--outputFile* The file path to where the rollback SQL will be written Optional

* If not specified, the futureRollbackCountSQL <value> output goes to STDOUT.

Note: The username and password attributes are not required for connections and systems which use alternate means of authentication.

futureRollbackCountSQL <value> command attributes

Attribute Definition Requirement
<value> The integer indicating the number of changes Liquibase would use to roll back Required

futureRollbackCountSQL <value> example output

When successful, the futureRollbackCountSQL <value> command produces the following output:

-- *********************************************************************
-- SQL to roll back currently unexecuted changes
-- *********************************************************************
-- Change Log: dbchangelog.xml
-- Ran at: 3/11/21 1:02 PM
-- Against: SCHEMA1@jdbc:oracle:thin:@localhost:1521:ORCL
-- Liquibase version: 4.1.1
-- *********************************************************************
-- Lock Database
LOCKGRANTED = TO_TIMESTAMP('2021-03-11 13:02:26.103', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE ID = 1 AND LOCKED = 0;
-- Rolling Back ChangeSet: dbchangelog.xml::89::liquibase
DROP TABLE SCHEMA1.table34558223;
-- Rolling Back ChangeSet: dbchangelog.xml::88::liquibase
DROP TABLE SCHEMA1.table3455822;