# 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.

Parent topic: Setting SQL Development Preferences
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