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: ‘disableTrigger’

Disable Trigger

Available Attributes

NameDescription
catalogNameName of the catalogE.g. 'cat'Supported by: oracle, postgresql
schemaNameName of the schemaE.g. 'public'
scopeE.g. 'A String'
tableNameName of the tableE.g. 'person'
triggerNameE.g. 'A String'
<changeSet author="liquibase-docs" id="disableTrigger-example">
    <pro:disableTrigger catalogName="cat"
            schemaName="public"
            scope="A String"
            tableName="person"
            triggerName="A String"/>
</changeSet>
changeSet:
  id: disableTrigger-example
  author: liquibase-docs
  changes:
  - disableTrigger:
      catalogName: cat
      schemaName: public
      scope: A String
      tableName: person
      triggerName: A String
{
  "changeSet": {
    "id": "disableTrigger-example",
    "author": "liquibase-docs",
    "changes": [
      {
        "disableTrigger": {
          "catalogName": "cat",
          "schemaName": "public",
          "scope": "A String",
          "tableName": "person",
          "triggerName": "A String"
        }
      }]
    
  }
}

SQL Generated From Above Sample (SQL Server)

DISABLE TRIGGER [public].[A String]  ON cat.[public].person;

Database Support

DatabaseNotesAuto Rollback
DB2/LUWNot SupportedYes
DB2/zNot SupportedYes
DerbyNot SupportedYes
FirebirdNot SupportedYes
H2Not SupportedYes
HyperSQLNot SupportedYes
INGRESNot SupportedYes
InformixNot SupportedYes
MariaDBNot SupportedYes
MySQLNot SupportedYes
OracleSupportedYes
PostgreSQLSupportedYes
SQL ServerSupportedYes
SQLiteNot SupportedYes
SybaseNot SupportedYes
Sybase AnywhereNot SupportedYes