Use the Table Name Filter window to control the tables that are listed in
the Tables page of the SQL Assist SmartGuide.
Fields
- Enter the table name filter specifies a character string to use
as a table name filter. The filtering characters are
case-sensitive. These characters limit the display to only table names
beginning with those characters. For example, if you enter EMP, only
table names that begin with EMP are listed, such as the EMPLOYEE table.
The % character is a wildcard character. Use it to position the
filter. For example, specifying %ID requests the display of all table
names that end with the characters ID. The specification N%ID requests
the display of all tables names that begin with N and end with ID.
- Table type specifies the types of tables to be included in the
filter.
Specifying the Tables for an SQL Statement
