By default,
in SQL statements that are in data development projects,
tables that belong to the current schema are not qualified in the
SQL Query 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 Query Builder,
the tables that belong to the current schema are now fully qualified.