SQL Query Builder Preferences

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.
Related concepts
SQL Query Builder
Related tasks
Setting SQL Development Preferences
Creating a SELECT Statement
Creating an INSERT Statement From a Values Set
Creating an INSERT Statement From a Subquery
Creating an UPDATE Statement
Creating a DELETE Statement
Building Expressions
Editing a SQL Statement
Running the SQL Statement Code
Related reference
Execution Plan View Options Preferences
Database Development General Preferences
SQL Editor Preferences
SQL Results View Options Preferences