Exchange Data With Clone

From RapidSQL
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action lets you issue an EXCHANGE statement with the DATA BETWEEN TABLE table1 AND table2 syntax, letting you swap data between a base table and its clone. To determine whether a table has a clone, see the Dependencies tab/panel on a Table editor or on the wizard for object actions such as Drop or Rename.

Platform Availability

To Exchange Data Between One or More Tables and their Clones

  1. Initiate a Clone Actions > Exchange Data With Clone action against one or more tables. For more information see Initiating an object operation.
    The Exchange Data With Clone dialog opens.
  2. Use the following table as a guide to understanding and modifying settings in this wizard:
Step Settings and tasks

Action Options

Lets you review the action you initiated.

Dependencies

Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies.

Preview

Displays the DDL that will execute the object action. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.

Topics