Moving a Table (XPS)

Use the Move option on the TABLE menu to move an existing table from the current database to another database. Press the M key, or highlight Move and press RETURN. The MOVE TABLE screen appears, as Figure 110 shows

Figure 110. The MOVE TABLE Screen

MOVE TABLE >> 
Select or enter the table to move.

----------------- mydata@mydbserv --------------- Press CTRL-W for Help -----

  clients 

 customer

 orders

This screen lists the names of tables that exist in the current database. You can move a table in one of the following ways:

To leave the MOVE TABLE screen without moving a table, you can press the Interrupt key to return to the TABLE menu.

You cannot use the Move option on the TABLE menu to move a table that has dependency objects such as views or referential constraints associated with it. To move such a table use the SQL Command MOVE with the CASCADE mode, which lets you drop those dependent objects and then the Move table operation can succeed.

After you select a table to move, DB-Access displays the "SELECT DATABASE" screen, which appears as Figure 111 shows.

Figure 111. The SELECT DATABASE Screen

SELECT DATABASE >> 
Select or enter a database to move the table to.

----------------- mydata@mydbserv --------------- Press CTRL-W for Help -----

  mydata@mydbserv 

 demodb@mydbserv

 personnel@mynewdb

This screen lists the names of databases that are available in the current instance. You can only move a table to a database that is in the same instance as the database you are moving the table from. You can select the database in one of these ways:

After you select a database to move the table to, DB-Access displays the "RENAME" screen, you can use this to rename the table. The "RENAME" screen appears as Figure 5-71 shows.

Figure 112. The RENAME Screen

RENAME >> 
Enter a new name for the table or press enter to keep the same name.

----------------- mydata@mydbserv --------------- Press CTRL-W for Help -----

To keep the original table and owner name, press RETURN at the prompt without typing anything. To rename the table, type the name at the prompt and press RETURN.

You can also change the owner of the table by including the name of the owner in the new table name. For example to change the table name to neworders and make the user john the owner you would type this:

After you press RETURN, DB-Access displays the CONFIRM Menu, which asks for confirmation before it moves the table, as Figure 113 shows.

Figure 113. The CONFIRMATION Screen

CONFIRM:  No  Yes >> 
No, I do not want to move it.

----------------- mydata@mydbserv --------------- Press CTRL-W for Help -----

The default is No to prevent you from accidentally moving a table. To move the highlighted table, press the Y key or use the right arrow key to highlight Yes and press RETURN. DB–Access then moves the table.