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.
Before you begin
All tables must be qualified in SQL
statements that are in data design projects.
The data development
project in which you want to qualify tables in SQL statements must
exist in the Data Project Explorer view.
Procedure
To enforce qualification of tables that belong to the
current schema in SQL statements:
- 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.
Results
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.