Via the Tools menu: Tools | Preferences | SQL
Right-clicking on a server in the SQL tree and select Global Settings
Right-clicking on an element in the Query Editor and select Global Settings
Studio's global SQL settings are configured from the SQL tab of Preferences.
There are three ways to open the SQL tab:
|
|
Via the Tools menu: Tools | Preferences | SQL |
|
|
Right-clicking on a server in the SQL tree and select Global Settings |
|
|
Right-clicking on an element in the Query Editor and select Global Settings |
The configurable settings in the SQL tab can be understood as follows:
|
|
Use SQL 'LIMIT' when Possible - LIMIT defines range of results returned by a query. Default=Enabled Note: Limit is restricted by Paging Size and paging location. Furthermore, LIMIT is not supported in all SQL servers; SQL Lite, PostgreSQL, and MySQL support LIMIT. |
|
|
Open Every Result in a New Tab - Determines how results are displayed. If enabled each query result is shown in a separate tab. |
|
|
Maximum Entries in Results Table - Maximum number of rows in a single page of results. Default= 100 Note: |
|
|
When Double-Clicking on a Table Node - Determines what will happen when a table node is double-clicked. Values include: Show Data, Show Metadata, Do Nothing (i.e., expand tree only). Default=Show Data |
|
|
When Double-Clicking on Other Nodes - Determines what will happen when another node type is double-clicked. Values include: Show Metadata, Do Nothing (i.e., expand tree only). Default=Do Nothing |
|
|
Date Format - Formats any date field returned as part of the results. Default=yyyy/MM/dd HH:mm:ss |
|
|
History Limit - Number of history elements shown in history area. Default=100 |
|
|
|
|
|
Related Links: Preferences Setting Code Completion Preferences |
|
|
|
