SQL Manager shortcuts
You can change shortcuts to your liking within the Global Shortcuts tab of the Environment options dialog.
|
Shift+Ctrl+R |
Register a DB2 node using Register Node Wizard |
|
Shift+Alt+R |
Register a database using Register Database Wizard |
|
Shift+Alt+U |
Unregister the selected database |
|
Shift+Ctrl+C |
Connect to a database |
|
Shift+Ctrl+D |
Disconnect from a database |
|
Ctrl+N |
Create a new object (the object type depends on the current selection) |
|
Ctrl+O |
Edit the selected object in its editor |
|
Ctrl+R |
Rename the selected object |
|
Shift+Del |
Drop the selected object |
|
Ctrl+Shift+C |
Collapse the current DB Explorer tree branch and switch selection to the parent tree node |
|
F11 |
View/hide Database Explorer |
|
Ctrl+F |
Search for an item in the DB Explorer tree |
|
Shift+Ctrl+T |
Open the To-Do List window |
|
F12 |
Show SQL Editor |
|
Shift+F12 |
Open a new instance of SQL Editor |
|
Shift+Ctrl+M |
Open SQL Monitor |
|
Shift+Ctrl+S |
Open SQL Script Editor |
|
Shift+Ctrl+L |
Open Localization Editor |
|
Ins |
Add a new table subobject (the subobject type depends on the current tab selection) |
|
Ctrl+I |
Start incremental search |
SQL Editor and SQL Script (fixed and default):
|
F9 |
Execute query/script |
|
Alt+F9 |
Execute selected only |
|
Ctrl+Alt+F9 |
Execute under cursor |
|
Ctrl+Alt+F2 |
Reset execution point (SQL Editor only) |
|
Shift+Ctrl+<digit> |
Toggle bookmark #<digit> |
|
Ctrl+Z |
Undo |
|
Shift+Ctrl+Z |
Redo |
|
Ctrl+F |
Search for text using the Find Text dialog |
|
Ctrl+R |
Replace text using the Replace Text dialog |
|
F3 |
Search next |
|
Ctrl+I |
Start incremental search |
|
Alt+G |
Go to line number (an input number dialog prompts for the number) |
|
Ctrl+L |
Load a script from an external file |
|
Ctrl+S |
Load the script to an external file |
|
Shift+Ctrl+F |
Format the SQL text using SQL Formatter |
|
Alt+<symbol> |
Switch to the query with <&symbol> in its name (SQL Editor only) |
|
Ctrl+J |
Insert a keyboard template |
|
Ctrl+Alt+Left |
Switch to the next tab of SQL Editor |
|
Ctrl+Alt+Right |
Switch to the previous tab of SQL Editor |
|
Ctrl+Alt+PgUp |
Switch to the last tab of SQL Editor |
|
Ctrl+Alt+PgDown |
Switch to the first tab of SQL Editor |
|
Ctrl+O |
Load a printing report from a file |
|
Ctrl+S |
Save the report to file |
|
Ctrl+P |
Open the Print dialog |
|
Ctrl+Home |
Go to the first page |
|
Ctrl+Up |
Go to the previous page |
|
Ctrl+Down |
Go to the next page |
|
Ctrl+End |
Go to the last page |
|
Ctrl+D |
Open Report Formatter |
|
Ctrl+\ |
Zoom 100% |
|
Ctrl+0 |
Zoom page width |
|
Ctrl+1 |
Whole page |
|
Ctrl+2 |
Two pages |
|
Ctrl+4 |
Four pages |
|
Ctrl+W |
Widen to source width |
|
Ctrl+M |
Show/hide margins |
|
Ctrl+K |
Set background color for the report |
Working with windows, menus and tabs:
|
Ctrl+Tab |
Switch to the next tab |
|
Ctrl+Alt-0 |
Open Windows List |
|
Ctrl+Alt+D |
Set defaults to all windows |
|
Ctrl+F6 |
Switch to the previous window |
|
F6 |
Switch to the next window |
|
Ctrl+W |
Close the active window |
|
Ctrl+Down |
Expand a collapsed menu |
|
Ctrl+Shift+N |
Move to the next tab in DB Explorer |
|
Ctrl+Shift+P |
Move to the previous tab in DB Explorer |