Simple mistakes are often made during SQL construction because of uneven left and right brackets. An easy way to identify the corresponding open and closed brackets for round brackets, curly brackets, or square brackets is to turn on the Bracket Pairing parameter in the Options window.
To enable or disable Bracket Pairing
Click 
Select the Editor tab.
Under the General section, select Bracket Pairing.
It is possible to comment or uncomment a line of text by selecting the line or highlighting the text and use the Comment and Uncomment functions. These two functions use the single line comment delimiter "- -". Commenting out a line means that the line will be ignored during execution.
To comment a line of text
Select the text or place the cursor at the line to be commented.
Click 
Notice that the beginning of a text or line prefix is marked with the " - - " delimiter.
To uncomment a line of text
Select the text or place the cursor at the line to be uncommented.
Click 
Notice the first occurrence of the " - - " comment delimiter will be removed.
There are many ways to customize the behavior of editable panes; the editor options can be set in the Options window under the Editor tab. These options include:
|
Editor Option |
Description |
|---|---|
|
Use tab characters |
Specify whether to use the tab character (ASCII 9) instead of spaces. |
|
Smart tab |
Specify whether to tab to align the next non-whitespace character of the preceding line. |
|
Use lowercase for object name |
Specify whether to use lowercase for object names. |
|
Specify whether to change to a block cursor for overwrite mode. Overwrite mode will overwrite existing text when is text entered at the cursor. You can toggle between Insert and Overwrite mode using the Insert key. | |
|
Show all characters |
Specify whether to show all characters including spaces, new lines and tabs. |
|
Right margin |
Specify whether to show the right margin and define the width. |
|
Gutter |
Specify whether to show the gutter and line number, and define the gutter width. |
|
Specify the block indent character size. | |
|
Tab size |
Specify the tab character length. |
The following list is the common shortcut keys provided for users to quickly accomplish tasks that is performed frequently within the Editor panes for SQL Editor and SQL Formatter window.
|
Action |
Shortcut Keys |
|---|---|
|
Delete next word |
Ctrl+Delete |
|
Delete previous word |
Ctrl+Backspace |
|
Delete next character |
Delete |
|
Delete previous character |
Backspace |
|
Delete current line |
Ctrl+Y |
|
Highlight a word |
Shift+Ctrl+Left or Right Arrow |
|
Highlight a character |
Shift+Left or Right Arrow |
|
Cursor forward a word |
Ctrl+Right Arrow |
|
Cursor backward a word |
Ctrl+Left Arrow |
|
Insert mode |
Insert |
|
Insert a new line character |
Shift+Ctrl+M |
|
Bring up Member Lookup |
Ctrl+Spacebar |
|
Bring up Argument Lookup |
Shift+Ctrl+Spacebar |
|
Comment |
Shift+Ctrl+C |
|
Uncomment |
Shift+Ctrl+N |
|
Indent |
Shift+Ctrl+I |
|
Outdent |
Shift+Ctrl+O |
|
Uppercase |
Shift+Ctrl+U |
|
Lowercase |
Shift+Ctrl+L |
|
Quick Find |
Ctrl+Alt+F |
|
Find |
Ctrl+F |
|
Find Next |
F3 |
|
Replace |
Ctrl+Alt+R |
|
Go to Line |
Ctrl+Alt+G |
|
Select All |
Ctrl A |
|
Cut |
Ctrl X |
|
Copy |
Ctrl C |
|
Paste |
Ctrl V |
|
Undo |
Ctrl Z |
|
Save |
Ctrl S |
