Change: ‘renameTrigger’

Rename Trigger

Available Attributes

NameDescriptionRequired ForSupportsSince
catalogNameName of the catalogoracle, postgresql
newTriggerNameallall
oldTriggerNameallall
schemaNameName of the schemaall
tableNameName of the tablepostgresqlall
<changeSet author="liquibase-docs" id="renameTrigger-example">
    <pro:renameTrigger catalogName="cat"
            newTriggerName="A String"
            oldTriggerName="A String"
            schemaName="public"
            tableName="person"/>
</changeSet>
changeSet:
  id: renameTrigger-example
  author: liquibase-docs
  changes:
  - renameTrigger:
      catalogName: cat
      newTriggerName: A String
      oldTriggerName: A String
      schemaName: public
      tableName: person
{
  "changeSet": {
    "id": "renameTrigger-example",
    "author": "liquibase-docs",
    "changes": [
      {
        "renameTrigger": {
          "catalogName": "cat",
          "newTriggerName": "A String",
          "oldTriggerName": "A String",
          "schemaName": "public",
          "tableName": "person"
        }
      }]
    
  }
}

SQL Generated From Above Sample (SQL Server)

sp_rename '[public].A String',
 'A String';

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