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 + 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

Filter

Ctrl+F

Filter the project list (or press ESC) to cancel.


Schema Compare, Schema View, Data Compare


Command

Shortcut

Description

Script

F9

For SC and DC generate script and display in Script Tab

Refresh

F5

For all refresh the current project

Run Script

F6

For SV run script shown in Query tab

Search

Ctrl + F

Enter search box to search current tab

Edit Project

Ctrl + E

Open the Edit tab for the the current project

Print

Ctrl + P

Print or show report list.


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.