Indicate the SQL Query Builder preferences.
Table 1. SQL Query Builder preferences
|Omit Current Schema in Generated SQL Statement
||Select to indicate that the table references qualified by the current schema become unqualified in the SQL code.
||If you omit the current schema, select its replacement:
Authorization ID — uses the user name from the connection profile.
The table references are qualified using the current schema name.
Schema Name — enter the schema to use as the current schema.