Database Development Preferences

Use database development preferences to customize development functionality.

You do not need to be connected to a database to set preferences.

Table 1. Database development preferences
Preference Desription
Database Development General Tooling Specify general preferences for routine objects.
Connection Level Option Specify default values for launching newly created routine objects and for the SQL Editor.
Create Database Specify defaults for creating new databases.
Export Format Specify formats for exporting or saving SQL results to a file.
Logging Specify how events are logged .
Perspective For each Database Development perspective, specify the perspective switching behavior.
Query Plan Specify options for displaying query plans.
SQL Editor Specify the behavior of the SQL Editor.
Code Assist Specify the behavior and appearance of the code assist features (also called content assist).
SQL Files Specify the system behavior when opening SQL files in the SQL Editor.
Templates Create new or edit existing SQL templates.
SQL Results View Specify preferences for the SQL Results view.
Related tasks
Setting SQL Development Preferences
Setting SQL Editor Preferences
Setting SQL Results View Preferences