In a data development project, the authorization ID is
used as the default current schema in SQL statements in the SQL Query
Builder. You can specify a different current schema.
Before you begin
The data development project for which you want to change
the current schema must exist in the Data Project Explorer view.
About this task
Important: The current schema that the SQL
Query Builder uses with SQL statements is not the current schema that
might be set for the database.
The SQL Query 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 Query Builder
associates the current schema with all unqualified tables in SQL statements.
Procedure
To change the current schema:
- 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.