generate-db-object

9.12.18 generate-db-object

Writes change log XML to copy the current state of the database object to a file.

Syntax

lb generate-db-object|geo {OPTIONS}

Options

Option	Description	Default
`-database-changelog-table-name\|-dactn <database-changelog-table-name>`	Name of table to use for tracking change history.	-
`-debug\|-de`	Enable debug output	-
`-default-schema-name\|-desn <default-schema-name>`	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`	-
`-fail-on-error\|-foe`	Set failonError attribute to true in changelog.	False
`-liquibase-schema-name\|-lbsn <liquibase-schema-name>`	Schema to use for Liquibase objects.	-
`-liquibase-tablespace-name\|-lbtn <liquibase-tablespace-name>`	Tablespace to use for Liquibase objects.	-
`-log\|-lo`	Enable logging	-
`-object-name\|-obn`	Name of the object.	-
`-object-type\| -obt`	Type of object.	-
`-output-default-schema\|-ouds <output-default-schema>`	Control whether names of objects in the default schema are fully qualified or not. 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
`-sql\|-sq`	Generate a sql file along with the changelog showing the DDL for the object. This sql is not intended to be used for anything other than review.	-
`-replace\|-re`	Set replaceIfExists attribute to true in changelog.	-
`-runalways\|-ra`	Set runAlways attribute to false in changelog	-
`-runonchange\|-rc`	Set runOnChange attribute to true in changelog.	-

Example

Generate the XML file for a specific object.

-- Set default output path
SQL> cd <output-files-path>
-- Generate xml files
SQL> lb generate-object -object-type table -object-name employees