By default, in SQL statements that are in data development projects,
tables that belong to the current schema are not qualified in the SQL builder.
You can qualify tables that belong to the current schema by changing the default
setting.
All tables must be qualified in SQL statements
that are in data design projects.
Prerequisite: The data development
project in which you want to qualify tables in SQL statements must exist in
the Data Project Explorer view.
To enforce qualification of tables that belong to the current
schema in SQL statements:
- Switch to the Data perspective.
- In the Data Project Explorer view, right-click a data development
project, and then click Properties on the pop-up menu.
- In the Properties window, click Development in
the navigation tree.
- On the Development page, clear the Omit current schema
in generated SQL statements check box.
- Click OK.
In any new or existing statement that you open in the SQL builder,
the tables that belong to the current schema are now fully qualified.