Liquibase® version 3.8.5 is now available! Get it for free.
2018 XML Announcement
News All Previous Posts >>

Subscribe for email updates

- and/or -

Change: ‘dropSynonym’

Drops a synonym

Available Attributes

NameDescription
objectTypeE.g. 'A String'Required for: db2
privateboolean
synonymCatalogNameSupported by: db2, db2z, oracle
synonymNameE.g. 'A String'
synonymSchemaName
<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
DB2/LUWSupportedNo
DB2/zSupportedNo
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