clear-checksums

Last published July 28, 2025

clear-checksums clears all checksums and nullifies the MD5SUM column of the DATABASECHANGELOG table. They will be re-computed on the next database update --changesets that have been deployed will have their checksums re-computed, and pending changesets will be deployed.

Uses

clear-checksums is typically used when there is a [MD5Sum Check Failed] error message and there is a need to clear the checksums from the DATABASECHANGELOG table.

Syntax

To run the clear-checksums command, specify the database driver, classpath, and URL in the Liquibase properties file. You can also specify these properties in your command line.

Then run the clear-checksums command:

liquibase clear-checksums

Command parameters

Attribute

Definition

Requirement

--url=<string>

The JDBC database connection URL.

Required

--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

--password=<string>

Password to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

Optional

--username=<string>

Username to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

Optional

Output

When successful, the clear-checksums command produces the following output:

Liquibase Pro 3.9.0 licensed to Liquibase Pro Customer until Tue Sep 22 19:00:00 CDT 2020 Liquibase command 'clear-checksums' was executed successfully.