SQL Delta Help
Keyboard Shortcuts
Project Manager and Tabs
|
Command |
Shortcut |
Description |
|
New Project |
Ctrl + N |
Create a new project. |
|
Edit Selected Project |
Ctrl + Enter |
Load the selected project into the edit project tab. |
|
Run Project |
Enter |
Run the selected project |
|
Close Tab |
Ctrl + W, Ctrl + F4 |
Close the current tab. |
|
Switch to a tab |
Alt + 0..9 |
Switch tabs where Tab 0 is the project manager and 1 through 9 are tabs to the right of the project manager. |
|
Global Options Menu |
F10 |
Show the global options menu |
|
Display feedback |
F11 |
Show the feedback form |
|
Help |
F1 |
Show the help tab |
|
Show Project Filters |
F4 |
Open the Project Manager filter bar and project-type filter controls. |
|
Project Text Filter |
Ctrl+F, Esc |
Focus or apply the Project Manager text filter. When the filter box is focused, Esc clears it. |
|
History |
Ctrl+H |
Show or hide the recent project activity panel. |
Schema Compare, Schema View, Data Compare
|
Command |
Shortcut |
Description |
|
Script |
F9 |
For Schema Compare and Data Compare results, generate the deployment script and open a script tab. |
|
Refresh |
F5 |
Refresh the current compare, view, or other active result surface. |
|
Execute Query or Script |
F6 |
Run the current Schema View query, or execute the current Schema Compare or Data Compare script tab. |
|
Switch Window Focus |
F7 |
Switch focus between the main result or editor panes on Schema Compare, Schema View, and shared script tabs. |
|
Next / Previous Search |
F8, Shift+F8 |
Move to the next or previous search match on compare and schema-view results surfaces. |
|
Edit Project |
Ctrl + E |
Open the Edit tab for the the current project |
|
Display |
Ctrl + D |
Open display and grouping options on Schema Compare results. |
|
|
Ctrl + P |
Print or show report list. |
Find and filter shortcuts are surface-specific. Project Manager uses F4 to show filters and Ctrl+F to focus or apply the text filter. Schema Compare results uses F4 for Filter, Ctrl+F for Find text, and Ctrl+Shift+R to toggle regular-expression searching. Editor and script surfaces use Ctrl+F for text search.
Script Editor
The script editor is a generic editor within SQL Delta and utilizes similar functionality and keyboard shortcuts in its various instances. There are some cases where the editor is read-only, such as display data script however largely the editor is a standard editor.
|
Command |
Shortcut |
Description |
|
Undo/Redo |
Ctrl+Z, Shift+Ctrl+Z |
Undo changes or redo changes to text |
|
Cut, Copy, Paste, Select All |
Ctrl+X, Ctrl+C, Ctrl+V, Ctrl+A |
The same as most editors, text can be cut, copied and pasted. |
|
Delete Word |
Ctrl+T |
Delete the current word |
|
Delete Line |
Ctrl+Y |
Delete the current line |
|
Delete to EOL |
Shift+Ctrl+Y |
Delete from cursor to the end of current line |
|
Insert a Line |
Ctrl+N |
Inserts a line break at the cursor |
|
Toggle Bookmark |
Ctrl+Shift+(0-9) |
Create a bookmark at a specific point in the script |
|
Goto Bookmark |
Ctrl+(0-9) |
Move the cursor to the bookmark, if it exists. |
|
Toggle Comment |
Ctrl+/ |
Toggles comment on or off |
|
Match Bracket |
Shift+Ctrl+B |
Moves the cursor forward or back to the associated bracket |
|
Column Select |
Shift+Ctrl+C |
Enter column selection mode |
|
Line Select |
Shift+Ctrl+L |
Enter Line selection mode (reverts from column selection mode and the default) |
|
Block Indent/Unindent |
Shift+Ctrl+I, Shift+Ctrl+U |
Indent the block of text right or left. |
|
Search for Text |
Ctrl+F |
Search text |
|
Replace Text |
Ctrl+R |
Search and replace text |
|
Search Next |
F3 |
Search again for the next occurrence of the search term |
|
Auto Complete |
Ctrl+Space |
Display list of objects ready for auto completion. Limited to schema view query. |