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

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.

About this task

To enforce qualification of tables that belong to the current schema in SQL statements:

  1. Switch to the Data perspective.
  2. In the Data Project Explorer view, right-click a data development project, and then click Properties on the pop-up menu.
  3. In the Properties window, click Development in the navigation tree.
  4. On the Development page, clear the Omit current schema in generated SQL statements check box.
  5. 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.

Feedback