Indicate the SQL Query Builder preferences.
Table 1. SQL Query Builder preferences
Field |
Description |
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. |
Current Schema |
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.
|