Changelog and Database Quality Checks
The Quality Checks for changelogs and databases are only available with a Liquibase Pro license key. These checks allow you to confirm the presence of specific objects and conditions in both the changelog and database to ensure their integrity. To execute these quality checks and improve the quality of your changelog and database changes, use the quality checks listed below with the scope changelog, database. To learn how to apply your checks to a specific scope, see the checks-scope
parameter.
For more information about using quality checks, see Quality Checks.
Checks
Short Name | Description | Enabled by Default |
---|---|---|
ObjectNameMustMatch
|
The ObjectNameMustMatch check allows you to confirm the listed object names conform to the supplied pattern. | false |
ObjectNameMustNotMatch
|
The ObjectNameMustNotMatch check allows you to confirm the listed object names conform to the supplied pattern and locate the object names that do not match so they can be corrected. | false |
OracleReservedKeywords
|
This check can be used to prevent Oracle's reserved keywords from being used in database object names. | false |
PostgresNonReservedKeywords
|
This check disallows Postgres non-reserved keywords from being used in database object names. See the SQL Key Words Appenix for complete list of keywords. | false |
PostgresReservedKeywords
|
This check disallows Postgres reserved keywords from being used in database object names. See the SQL Key Words Appendix for complete list of keywords. | false |
SQLServerFutureReservedKeywords
|
This check disallows SQL Server's future reserved keywords from being used in database object names. See Reserved Keywords (Transact-SQL) for complete list of keywords. | false |
SQLServerODBCReservedKeywords
|
This check disallows SQL Server's ODBC reserved keywords from being used in database object names. See Reserved Keywords (Transact-SQL) for complete list of keywords. | false |
SQLServerReservedKeywords
|
This check disallows SQL Server reserved keywords from being used in database object names. See Reserved Keywords (Transact-SQL) for complete list of keywords. | false |
TableColumnLimit
|
The TableColumnLimit check allows you to ensure that no table described in a changelog or existing in a database target has more than a threshold number of columns. | true |
TableCommentCheck
|
The TableCommentCheck check allows you to flag any table that does not have a comment. Note that this is not a check for a Liquibase changelog comment. | true |
TableCommentPatternCheck
|
The TableCommentPatternCheck check triggers when specific user-supplied patterns are present in table comments. | false |