In a data development project, you can specify whether to qualify tables that belong to the current schema in the SQL statements that you specify in the SQL builder.
The Omit current schema in generated SQL statements check box in the project Properties window is the option that controls whether to qualify tables. When the check box is selected, the current schema qualifier is omitted in SQL statements in the SQL builder. The check box is selected by default in a project.
If the check box is selected, when you specify an SQL statement in the SQL builder, the tables that are in the current schema are not qualified. If you type a current schema qualifier for a table in the SQL Source pane, when you move the focus out of the SQL Source pane, the SQL builder removes the qualifier.
The current schema for SQL statements is determined by the option that is selected in the project Properties window. By default, theUse authorization ID as current schema option is selected. If you select Specify current schema in SQL format, you must specify the current schema name in SQL format. If the name contains lower case letters or spaces, you must surround the name with quotation marks.