MIGRATE TABLE INTO

Description

MIGRATE TABLE INTO syntax is used to migration table from source to target

Syntax

Grammar Railroad diagram

MigrateTableInto ::=
  'MIGRATE' 'TABLE' migrationSource '.' tableName 'INTO' (databaseName '.')? tableName
migrationSource ::=
  identifier
databaseName ::=
  identifier
tableName ::=
  identifier

Supplement

• When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.

Example

• Migrate table from source to current database

MIGRATE TABLE ds_0.t_order INTO t_order;

• Migrate table from source to specified database

UNREGISTER MIGRATION SOURCE STORAGE UNIT ds_1, ds_2;

Reserved word

MIGRATE, TABLE, INTO

Related links

• Reserved word