SQL Editor |
The SQL Editor is used every time you work with SQL statements in Visual Case (designing stored procedures, views, triggers and constraints. It's also used to review and modify the SQL scripts that are created and run whenever you forward-engineer a database through ODBC.
The editor has several advanced features that make working with SQL a breeze:
Syntax
Highlighting
Keywords, operators, datatypes, and table and column names are all
formatted to make your SQL easy to read and understand.
Intellitype
Prompt
The editor will provide a drop-down list of possible keywords whenever
you start typing a word.
Cut,
Copy & Paste
Undo
& Redo
Find
& Replace
Block
Commenting & Uncomment Buttons
Block
Indenting
Pressing the Tab key will
indent the selected text block. Shift-Tab
will un-indent the selected text.
Shortcut
Keys
The SQL Editor supports the following shortcut keys:
|
Cut, Copy & Paste |
|
|
Ctrl-x |
Cut |
|
Ctrl-c |
Copy |
|
Ctrl-v |
Paste |
|
Undo & Redo |
|
|
Ctrl-y |
Redo |
|
Ctrl-z |
Undo |
|
Find & Replace |
|
|
Ctrl-f |
Find |
|
Ctrl-r |
Replace |
|
Block Indenting |
|
|
Tab |
Indent the highlighted text |
|
Shift-Tab |
Unindent the highlighted text |
|
Navigation |
|
|
Home |
Go to the beginning of the line |
|
End |
Go to the end of the line |
|
Ctrl-Home |
Go to the beginning of the SQL text |
|
Ctrl-End |
Go to the end of the SQL text |
|
Text Highlighting |
|
|
Shift-Home |
Select the text from the cursor to the beginning of the line |
|
Shift-End |
Select the text from the cursor to the end of the line |
|
Ctrl-Shift-Home |
Select the text from the cursor to the beginning of the SQL text |
|
Ctrl-Shift-End |
Select the text from the cursor to the end of the SQL text |
|
Text Deleting |
|
|
Backspace |
Delete previous character |
|
Delete |
Delete following character |
|
Ctrl-Backspace |
Delete previous word |
|
Ctrl-Delete |
Delete following word |