5.3.8 Configuring Quick SQL Settings
Configure settings inline to explicitly set SQL syntax generation options, or click the Settings button at the top of the right pane to declaratively set the generation options.
- Configuring Settings Declaratively
Configure settings declaratively by clicking the Settings button at the top of the right pane. - Configuring Settings Inline
Configure settings inline to explicitly set SQL syntax generation options.
Parent topic: Using Quick SQL
5.3.8.1 Configuring Settings Declaratively
Configure settings declaratively by clicking the Settings button at the top of the right pane.
To configure settings declaratively:
Parent topic: Configuring Quick SQL Settings
5.3.8.2 Configuring Settings Inline
Configure settings inline to explicitly set SQL syntax generation options.
You can configure settings inline to explicitly set SQL syntax generation options. When configuring setting inline:
- Settings must start on a new line. To enter multiple settings, begin with
# settings =
. To enter a single setting per line, use#
. - All values are case insensitive.
- Brackets, spaces, and commas can be added for clarity but are ignored.
- To have all settings generated use
# verbose: true
Entering settings directly into the Quick SQL Shorthand pane ensures the same SQL generation options are utilized even if you download the script and later paste it back. For example, enter the following to prefix all table names with TEST and generate for schema OBE:
# settings = { prefix: "test", schema: "OBE" }.
Alternatively, enter each setting on a separate line for the same result:
# prefix: "test"
# schema: "OBE"
Tip:
To view a listing of settings, by clicking Help and then Settings.
Parent topic: Configuring Quick SQL Settings