Liquibase® version 3.8.2 is now available! Get it for free.
2018 XML Announcement
News 5 Ways to Fix a Bad Database Change in Liquibase
04 Dec 2019

- and/or -

All Previous Posts >>

Change: ‘dropSynonym’

Drops a synonym

Available Attributes

NameDescriptionRequired ForSupportsSince
objectTypedb2all
privateall
synonymCatalogNamedb2, db2z, oracle
synonymNameallall
synonymSchemaNameall
<changeSet author="liquibase-docs" id="dropSynonym-example">
    <pro:dropSynonym objectType="A String"
            private="true"
            synonymName="A String"/>
</changeSet>
changeSet:
  id: dropSynonym-example
  author: liquibase-docs
  changes:
  - dropSynonym:
      objectType: A String
      private: true
      synonymName: A String
{
  "changeSet": {
    "id": "dropSynonym-example",
    "author": "liquibase-docs",
    "changes": [
      {
        "dropSynonym": {
          "objectType": "A String",
          "private": true,
          "synonymName": "A String"
        }
      }]
    
  }
}

SQL Generated From Above Sample (SQL Server)

DROP SYNONYM [A String];

Database Support

DatabaseNotesAuto Rollback
DB2SupportedNo
DB2SupportedNo
DerbyNot SupportedNo
FirebirdNot SupportedNo
H2Not SupportedNo
HyperSQLNot SupportedNo
INGRESNot SupportedNo
InformixNot SupportedNo
MariaDBNot SupportedNo
MySQLNot SupportedNo
OracleSupportedNo
PostgreSQLNot SupportedNo
SQL ServerSupportedNo
SQLiteNot SupportedNo
SybaseNot SupportedNo
Sybase AnywhereNot SupportedNo