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:
- 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, click Specify current schema
in SQL format.
- Type the name in the Current schema field. If the schema name contains lowercase letters or spaces, surround the
name with quotation marks.
- Click OK.