Use the Schema(s) to View window to add tables to those listed in the
Tables page of the SQL Assist SmartGuide.
Fields
- Enter the additional schema name(s) to view specifies a
character string to use as a schema name filter. These characters add
to the table name list the table names whose schema begins with those
characters. For example, if you enter TEST, table names whose schema
begins with TEST are added to the list, such as the TEST.EMPLOYEE
table. The % character is a wildcard character. Use it to
position the schema name filter. For example, specifying %ST requests
the addition of all table names whose schema ends with the characters
ST. The specification T%ST requests the addition of all tables names
that begin with T and end with ST.
Push buttons
- View all add the name of all tables in the database to the
table name list.
Specifying the Tables for an SQL Statement
