Change: ‘createSynonym’
Creates a synonym
Available Attributes
| Name | Description |
|---|---|
| objectCatalogName | |
| objectName | E.g. 'A String' |
| objectSchemaName | |
| objectType | E.g. 'A String'Required for: db2 |
| private | boolean |
| replaceIfExists | boolean |
| synonymCatalogName | |
| synonymName | E.g. 'A String' |
| synonymSchemaName |
<changeSet author="liquibase-docs" id="createSynonym-example">
<pro:createSynonym objectName="A String"
objectType="A String"
private="true"
replaceIfExists="false"
synonymName="A String"/>
</changeSet>changeSet:
id: createSynonym-example
author: liquibase-docs
changes:
- createSynonym:
objectName: A String
objectType: A String
private: true
replaceIfExists: false
synonymName: A String{
"changeSet": {
"id": "createSynonym-example",
"author": "liquibase-docs",
"changes": [
{
"createSynonym": {
"objectName": "A String",
"objectType": "A String",
"private": true,
"replaceIfExists": false,
"synonymName": "A String"
}
}]
}
}SQL Generated From Above Sample (SQL Server)
CREATE SYNONYM [A String] FOR [A String];Database Support
| Database | Notes | Auto Rollback |
|---|---|---|
| DB2/LUW | Supported | Yes |
| DB2/z | Supported | Yes |
| Derby | Not Supported | Yes |
| Firebird | Not Supported | Yes |
| H2 | Not Supported | Yes |
| HyperSQL | Not Supported | Yes |
| INGRES | Not Supported | Yes |
| Informix | Not Supported | Yes |
| MariaDB | Not Supported | Yes |
| MySQL | Not Supported | Yes |
| Oracle | Supported | Yes |
| PostgreSQL | Not Supported | Yes |
| SQL Server | Supported | Yes |
| SQLite | Not Supported | Yes |
| Sybase | Not Supported | Yes |
| Sybase Anywhere | Not Supported | Yes |