Liquibase provided Update commands that will execute DDL and DML scripts and update the database. some of the commands are listed below
| Command | Description | |
|---|---|---|
| dropAll | The drop-all command that drops all the database objects own by the user and remove all database objects and reset the database to empty state |
|
| executeSql | The executeSql command, will connect to the database and run SQL queries |
|
| update | apply the DDL and DML commands to the database |
|
| updateSql | updateSql helper command which lets the user inspect the raw SQL. |
|
| updateCount | the updateCount command executes a number of ChanegSets provided as an argument. |
|
| updateCountSql | The updateCountSql is a helper command that lets the DBA inspect the raw underlying SQL the Liquibase will execute while updating databases |
|
| updateTestingRollback | updateTestingRollback first deploys the ChangeSet, then executes the rollback command in reverse order, and again deploys the ChangeSet against the database. |
|
| updateToTag | updateToTag command will only execute the update from the start of the ChangeSet to the tag ChangeSet. |
|
| updateToTagSql | updateSql helper command is provided by Liquibase which lets the user inspect the raw SQL. |
|
| validate | validate command that checks any possible error in the ChangeLog file that may result in updation failure |
lets see them one by one
