Enforcing qualification of tables in SQL statements
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
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.