dropAll drops all database objects owned by the user.
dropAll will not drop functions, procedures, or packages for the community version of Liquibase. Functions, procedures, packages, and synonyms can only be dropped for Liquibase Pro supported objects.
dropAll is typically used when there is a need to prepare an environment schema to be identical to another environment schema.
dropAll is useful in the developer and test environments to remove unwanted objects to reset the database to “empty”.
The command makes it easier to standardize another schema, compared to manually deleting the objects, or dropping and recreating the desired schema.
dropAll should not be used in a production environment to prevent removal of required objects.
To run the
dropAll 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
dropAll global attributes
||Specifies the JDBC database connection URL||Required|
||Specifies the database username||Required|
||Specifies the database password||Required|
Note: The username and password attributes are not required for connections and systems which use alternate means of authentication.
When successful, the
dropAll command produces the following output:
Liquibase Pro 3.9.0 by Datical licensed to Liquibase Pro Customer until Tue Sep 22 19:00:00 CDT 2020 All objects dropped from MVN_UAT@jdbc:oracle:thin:@support.datical.net:1521:ORCL Liquibase command 'dropAll' was executed successfully.