Uses

When you run database comparison commands like diff-changelog or drop-all, Liquibase identifies database objects that exist in the target database but not in the reference database. For synonyms, Liquibase handles private and public synonyms differently:

- Private synonyms are always included in drop operations, regardless of this parameter setting - Public synonyms are included in drop operations by default (--drop-public-synonyms=true)

You may want to set --drop-public-synonyms to false in the following scenarios:

- Shared public synonyms: Your environment has enterprise-wide public synonyms that are managed separately and should not be modified during schema comparisons - Multi-application databases: Public synonyms are used by multiple applications or schemas, and dropping them would affect other systems - Selective synchronization: You want to synchronize schema-specific objects while preserving shared public synonyms

Keep the default value of true when you want complete database synchronization, including all synonym objects.

Note: This parameter applies to Oracle and SQL Server databases that support synonym objects.

Syntax

You can set this parameter in the following ways:

For more information, see Working with command parameters.

Change history