ROLLBACK MIGRATION

Description

The ROLLBACK MIGRATION syntax is used to rollback migration process.

Syntax

Grammar Railroad diagram

RollbackMigration ::=
  'ROLLBACK' 'MIGRATION'  migrationJobId 
migrationJobId ::=
  string

Supplement

• migrationJobId needs to be obtained through SHOW MIGRATION LIST syntax query

• After the statement is executed, the target will be cleaned up

Example

• Rollback migration process

ROLLBACK MIGRATION 'j010180026753ef0e25d3932d94d1673ba551';

Reserved word

ROLLBACK, MIGRATION

Related links

• Reserved word
• SHOW MIGRATION LIST