ROLLBACK MIGRATION

Description

The ROLLBACK MIGRATION syntax is used to rollback migration process.

Syntax

  1. RollbackMigration ::=
  2. 'ROLLBACK' 'MIGRATION' migrationJobId
  3. migrationJobId ::=
  4. 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
  1. ROLLBACK MIGRATION 'j010180026753ef0e25d3932d94d1673ba551';

Reserved word

ROLLBACK, MIGRATION