Select Tables Screen (Magic xpi 4.7)
The Select Tables screen shows a list of the tables found in the database.
To use the Select Tables screen:
-
Select the required DB operation from the DB Operation drop-down list. This drop-down list is only enabled when using a Database Destination.
-
In the Available Tables field, select the table and click the Add button. The selected table moves to the Selected Tables field. To remove a table from the Selected Tables column, select a table and click the Remove button.
|
|
For Source objects you can select more than one table. For Destination objects you can only select one table.
|
-
Click Next to display the Select Columns screen.
The Select Tables screen contains the following additional fields:
|
|
|
|
Filter Definitions Only
|
This check box lets you select the owner and the tables that will be fetched for the Database wizard's Select Table operation. You can select a specific owner and view all of this owner's tables, or you can select only a subset of these tables. You can also select All to view all tables from all owners, and then select the tables to be used. This may take a long time if there is a large number of tables.
|
|
Available List By Owner
|
This drop-down list enables you to filter the list according to a certain owner, or to display all of the tables. Note that there will also be system tables in the list. Select All to display all available tables.
|
