This can be the name of a TABLE,
VIEW, SYNONYM, or ALIAS.
TYPE
The type of query you want to compose.
SELECT
Composes a basic query for selecting data from the columns of a table
or view. Type the other clauses you need when the query is displayed. To
select more than one table, use the DRAW command for each table. This is the
default query type.
INSERT
Composes a basic query for inserting data into a table or view. When
the query is displayed, type the new data to the left of the column names.
UPDATE
Composes a basic query to change the values of specified rows of a table
or view. When the query is displayed, type your changes to the right of the
column names and delete the lines you do not need.
IDENTIFIER
Specifies an identifier to uniquely designate the table in the composed
query. This option is ignored when TYPE=INSERT.
correlationname
A user-defined name that becomes a correlation name for the table in
the composed query. This name is used to qualify columns in the query to avoid
ambiguity, or to establish a correlated reference for subqueries. It can also
be used merely as a better name for the table to improve readability of the
query.
If you do not specify this option, no correlation name is added to
the composed query.