Changing the current schema

In a data development project, the authorization ID is used as the default current schema in SQL statements in the SQL builder. You can specify a different current schema.

Prerequisite: The data development project for which you want to change the current schema must exist in the Data Project Explorer view.

Important: The current schema that the SQL builder uses with SQL statements is not the current schema that might be set for the database.

The SQL builder uses the current schema value only when the Omit current schema in generated SQL statements check box is selected in the data development project. In this case, the SQL builder associates the current schema with all unqualified tables in SQL statements.

To change the current schema:

  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, click Specify current schema in SQL format.
  5. Type the name in the Current schema field. If the schema name contains lowercase letters or spaces, surround the name with quotation marks.
  6. Click OK.
Related concepts
Unqualified tables in SQL statements
Related tasks
Enforcing qualification of tables in SQL statements

Feedback