enableTrigger
Enables a trigger.
Available attributes
catalogName |
Name of the catalog |
|
oracle, postgresql |
|
schemaName |
Name of the schema |
|
all |
|
scope |
|
|
all |
|
tableName |
Name of the table |
|
all |
|
triggerName |
|
all |
all |
|
XML example
<changeSet author="liquibase-docs" id="enableTrigger-example">
<pro:enableTrigger catalogName="cat"
schemaName="public"
scope="A String"
tableName="person"
triggerName="A String"/>
</changeSet>
YAML example
changeSet:
id: enableTrigger-example
author: liquibase-docs
changes:
- enableTrigger:
catalogName: cat
schemaName: public
scope: A String
tableName: person
triggerName: A String
JSON example
{ "changeSet": { "id": "enableTrigger-example", "author": "liquibase-docs", "changes": [ { "enableTrigger": { "catalogName": "cat", "schemaName": "public", "scope": "A String", "tableName": "person", "triggerName": "A String" } }] } }
SQL example
ENABLE TRIGGER [public].[A String] ON cat.[public].person;
Database support
DB2/LUW |
Not Supported |
Yes
|
DB2/z |
Not 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 |
Supported
|
Yes
|
SQL Server |
Supported
|
Yes
|
SQLite |
Not Supported |
Yes
|
Sybase |
Not Supported |
Yes
|
Sybase Anywhere |
Not Supported |
Yes
|