Operation on Table Page

Select the database tables in which you want to perform the operation.

• Operation on Table Page
• Table 1 - Review and manage parent database table relationships
• Table 2 - Review and filter columns from selected database tables
• Table 3 - Review and edit SQL query

Operation on Table Page

Element	Description
Schema	Select the database schema that includes the tables to process.
Table Name	Enter a filter with which to search the schema (for example, “Cust% “ to search for tables starting with “Cus”t in the name).
Table Type	Specify the table type filter to get a subset of the appropriate database objects, then click Search. TABLE VIEW ALL
Search	Select the file that you want to download or delete.
Filter By	Enter the initial letters to filter the display of table names.
Table Names	Select the tables to import. Note: It is recommended that you to import the tables together for the adapter to automatically recognize the relationship. If you import the tables separately, you must explicitly create the table relationship.
Import Tables	Click to import the tables. The page is refreshed for you to select the parent database table.
Select the parent database table	Select the parent (root) table from the list. If using multiple related tables, this is the top-level parent table in the relationship. After making your selection, the page is refreshed for you to view and edit the table relationships.
Add || Remove Tables	Click to add more tables or remove tables no longer in use.
Review and manage parent database table relationships	Click Edit to view and edit the table relationships. The relationships automatically identified by the adapter are displayed. See Table 1 - Review and manage parent database table relationships.
Review and filter columns from selected database tables	Click Edit to view and edit the table attributes. You can deselect any attributes to exclude from the database queries. Primary key attributes cannot be excluded. See Table 2 - Review and filter columns from selected database tables.
Review and edit SQL query	Click Edit to view and edit the default SQL query. See Table 3 - Review and edit SQL query. Note: This field is available for a Select operation on the table.

Table 1 - Review and manage parent database table relationships

Element	Description
Create New	Click to create a new relationship.
Relations	View the existing parent and child table relations automatically created by the adapter.

Table 2 - Review and filter columns from selected database tables

Element	Description
Attributes Tree	View and deselect attributes automatically created by the adapter.

Table 3 - Review and edit SQL query

Element	Description
SQL Edit	Click to manually edit the query in the SQL Query field. Use this field to add any necessary arguments or parameters.
Maximum Number of Records to be fetched	Select the number of records to fetch with this SQL query.

Note:

This is only applicable for a Select operation on a table.