9.12.41 update-sql

Generate the SQL identified in the changelog for review before running the update command.

Syntax

Liquibase|lb update-sql|ups {OPTIONS}

Liquibase uses the raw SQL to apply database changes you have added to the changelog file.

Options

Option	Description	Default
Required
-changelog-file|-chf	The root changelog file.	-
Optional
-contexts|-co	Context string to use for filtering which changes to operate on.	-
-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	-
-labels|-la	Label expression to use for filtering the changes to operate on.	-
-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 INFO level (no debug flag). Debug logging is FINEST level (both log and debug flag).	-
-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
-output-file|-ouf	The name of the file to write the output to.	-
-overwrite-files|-ovf	Overwrite any existing files in the directory. This will not affect other files.	-
-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 that could be used insecurely. An example is disabling remote XML entity support.	True
-override-app-alias|-ovaa	Override value to be used for the APEX application alias.	-
-override-app-id|-ovai	Override value to be used for the APEX application id.	-
-override-app-schema|-ovas	Override value to be used for the APEX workspace schema.	-
-override-app-workspace|-ovaw	Override value to be used for the APEX application workspace.	-