createSynonym
Creates a synonym.
Available attributes
objectCatalogName |
|
|
all |
|
objectName |
|
all |
all |
|
objectSchemaName |
|
|
all |
|
objectType |
|
db2 |
all |
|
private |
|
|
all |
|
replaceIfExists |
|
|
all |
|
synonymCatalogName |
|
|
all |
|
synonymName |
|
all |
all |
|
synonymSchemaName |
|
|
all |
|
XML example
<changeSet author="liquibase-docs" id="createSynonym-example">
<pro:createSynonym objectName="A String"
objectType="A String"
private="true"
replaceIfExists="false"
synonymName="A String"/>
</changeSet>
YAML example
changeSet:
id: createSynonym-example
author: liquibase-docs
changes:
- createSynonym:
objectName: A String
objectType: A String
private: true
replaceIfExists: false
synonymName: A String
JSON example
{ "changeSet": { "id": "createSynonym-example", "author": "liquibase-docs", "changes": [ { "createSynonym": { "objectName": "A String", "objectType": "A String", "private": true, "replaceIfExists": false, "synonymName": "A String" } }] } }
SQL example
CREATE SYNONYM [A String] FOR [A String];
Database support
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
|