Filter
Top Products
6.10 Omitting Schema Names
In the examples of SQL statements provided so far, table names have been qualified with a schema name, such as in
STOCKS.STOCK. This section explains how to use a table declaration in which the schema name qualifier is not
specified.
Specify the table name used by the application program and the name of the schema in which the table is located in
the table declaration. After the table declaration has been specified, when an SQL statement is entered, the schema
name qualifier can be omitted from the table name specification. The following is an example of specifying a table
declaration:
Example:
In this example, the STOCK table, the ORDER table, and the COMPANY table have been declared in
the table declaration so the schema name qualifier can be omitted from the table name specification.
124