Table dialog box
The Table dialog box is where you select the table from which to import the structure. You can restrict the import to specific columns (fields) within the selected table. Once you have selected a table and specified the columns to use, you can define filters on the columns to further restrict the import.
These are the dialog box options:
Option | Description |
---|---|
Catalog | Schema or database name set under the data source properties. Click the ellipsis button to open the dialog box where you can select another schema or database. This is for Oracle and SQL Server data sources. |
Table | Name of the table from which to load the structure. Click the ellipsis button to open the Choose Table dialog box where you can select the table to use. This is for Oracle and SQL Server data sources. |
Fields | Opens the Choose Fields dialog box. From the Available fields list, select the columns you want and move them to the Selected fields list. The columns in the Selected fields list appear on the Columns tab where they can be mapped. Use the arrow buttons to move fields between the lists. |
Rows | Displays the first 100 rows from the selected table. |
Opens the Sort dialog box. | |
Currently defined filters. Click | to define or change a filter. Filtering lets you reduce the amount of data being loaded.