dropSynonym
Drops a synonym.
Available attributes
objectType |
|
db2 |
all |
|
private |
|
|
all |
|
synonymCatalogName |
|
|
db2, db2z, oracle |
|
synonymName |
|
all |
all |
|
synonymSchemaName |
|
|
all |
|
XML example
<changeSet author="liquibase-docs" id="dropSynonym-example">
<pro:dropSynonym objectType="A String"
private="true"
synonymName="A String"/>
</changeSet>
YAML example
changeSet:
id: dropSynonym-example
author: liquibase-docs
changes:
- dropSynonym:
objectType: A String
private: true
synonymName: A String
JSON example
{ "changeSet": { "id": "dropSynonym-example", "author": "liquibase-docs", "changes": [ { "dropSynonym": { "objectType": "A String", "private": true, "synonymName": "A String" } }] } }
SQL example
DROP SYNONYM [A String];
Database support
DB2/LUW |
Supported
|
No |
DB2/z |
Supported
|
No |
Derby |
Not Supported |
No |
Firebird |
Not Supported |
No |
H2 |
Not Supported |
No |
HyperSQL |
Not Supported |
No |
INGRES |
Not Supported |
No |
Informix |
Not Supported |
No |
MariaDB |
Not Supported |
No |
MySQL |
Not Supported |
No |
Oracle |
Supported
|
No |
PostgreSQL |
Not Supported |
No |
SQL Server |
Supported
|
No |
SQLite |
Not Supported |
No |
Sybase |
Not Supported |
No |
Sybase Anywhere |
Not Supported |
No |