Specifying the tables for an SQL statement

Use the Tables page of the SQLAssist SmartGuide to specify the tables that are accessed in an SQL statement.


Tables page of SQLAssist SmartGuide

The Table name field lists the tables that you can access in the database identified by the currently selected connection alias. By default, the tables listed are those whose schema is the user ID specified for the database connection. If no tables in the database have that schema, all the tables in the database are listed.

You can add or remove table names displayed in the list, by selecting View schema(s). You can filter the table names displayed in the list by selecting Filter table(s).

Selecting View schema(s) opens the Schema(s) to View window.


Schema(s) to View window

When you finish selecting schemas to view, select OK. This closes the Schema(s) to View window.

Selecting Filter table(s) opens the Table Name Filter window.


Table Name Filter window

You are then prompted to enter the following information for the filter:

When you finish entering information that filters table names in the list, select OK. This closes the Table Name Filter window.

Select a table for the SQL statement by checking the checkbox next to the table name in the Table name list. You can select more than one table.

When you finish, select Next. This displays the Join page of the SQL Assist SmartGuide. Use this page to specify table joins for the SQL statement. You can also display any page in the SQL Assist SmartGuide by selecting its tab.

When you complete the specification of your SQL statement, select Finish. This generates the code for the SQL statement and closes the SQL Assist SmartGuide.

To cancel visual composition of the SQL statement, select Cancel.


Joining tables
Specifying search conditions
Specifying result columns
Sorting the result set
Remapping data to a different SQL data type
Displaying the SQL statement