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
Prerequisite: 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.
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.