# 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