Move a table

To move a table to a different schema:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the Tables container.
  5. Right-click the table and select Cut.
  6. Right-click the schema you want to move the table to and select Paste.

OR

You can drag the table and drop it on anther schema on the same system or a different system.

Note: Moving a table to a new location does not always remove it from the source system. For example, if you have read authority but not delete authority to the source table, the table will be moved to the target system. However, it will not be deleted from the source system, causing two instances of the table to exist.

Distributed data management (DDM) is used by System i Navigator to actually move or copy the table. If the source system is Version 4 Release 4 or later and if the target system is Version 4 Release 2 or later, the operation will be performed using DDM over TCP/IP. Otherwise the operation will be performed using DDM over SNA. For a move or copy using DDM over SNA, the names by which System i Access knows the systems must be the same as the remote location names specified in the APPC or APPN device descriptions used by DDM. For a move or copy using DDM over TCP/IP, TCP communications must be enabled between the systems. For TCP/IP, it is important to note that TCP/IP must be enabled between the systems as they are known to System i Access.