9.12.11 drop-all
Drops all database objects owned by the user.
Syntax
Liquibase|lb drop-all|dra {OPTIONS}Options
| Option | Description | Default |
|---|---|---|
-database-changelog-table-name|-dactn |
Name of table to use for tracking change history. | - |
-debug|-de |
Enable debug output. | - |
-default-schema-name|-desn |
The default schema name to use for the database connection. | - |
-defaults-file|-def |
Fully qualified path to the properties file you want
to use. Example:
-defaults-file/tmp/liquibase.properties |
- |
-liquibase-schema-name|-lbsn |
Schema to use for Liquibase objects. | - |
-liquibase-tablespace-name|-lbtn |
Tablespace to use for Liquibase objects. | - |
-log|-lo |
Enable logging. Standard logging is Debug logging is |
- |
-output-default-schema|-ouds |
Control whether names of objects in the default schema are fully qualified or not. If true they are qualified. If false, only objects outside the default schema are fully qualified. | False |
-search-path|-sep |
Complete list of locations to search for files such as changelog files. You can specify multiple paths by separating them with commas. |
- |
-secure-parsing|-scp |
If true, remove functionality from file parsers, which can be used insecurely. An example is disabling remote XML entity support. |
True |
-schemas|-sc |
Schemas to include operation. | - |
Example
To drop all database objects owned by the user, enter:
SQL> lb drop-all