Online Documentation for SQL Manager for MySQL
SQL Manager shortcuts
Shift+Ctrl+R |
Register a MySQL host using Register Database 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+Ins |
Add a parameter in Procedure Editor and Function Editor |
Ctrl+Del |
Remove a parameter in Procedure Editor and Function Editor |
Ctrl+Up |
Move an argument up in Procedure Editor and Function Editor |
Ctrl+Down |
Move an argument down in Procedure Editor and Function Editor |
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+<digit> |
Go to bookmark #<digit> |
Ctrl+Q,N |
Go to next bookmark |
Ctrl+Q,P |
Go to previous bookmark |
F2 |
Drop marker to current position |
Esc |
Collect marker (jump back) |
Shift+Esc |
Swap marker to current position |
Ctrl+Z; Alt+BkSp |
Undo |
Shift+Ctrl+Z; Shift+Alt+BkSp |
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 |
Сtrl+D |
Toggle query results display mode (at the Edit tab or at a separate one) |
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+Q,S |
Move cursor to beginning of line |
Ctrl+Q,D |
Move cursor to end of line |
Ctrl+Q,R |
Move cursor to absolute beginning |
Ctrl+Q,C |
Move cursor to absolute end |
Ctrl+O,N |
Normal selection mode |
Ctrl+O,L |
Line selection mode |
Ctrl+O,C |
Column selection mode |
Shift+Ctrl+Left |
Select the previous word |
Shift+Ctrl+Right |
Select the next word |
Shift+Home |
Select text to the beginning of the line |
Shift+End |
Select text to the end of the line |
Shift+PageUp |
Select one page up |
Shift+PageDown |
Select one page down |
Shift+Ctrl+PageUp |
Select text to the first line on the page |
Shift+Ctrl+PageDown |
Select text to the last line on the page |
Shift+Ctrl+Home |
Select text to the absolute beginning |
Shift+Ctrl+End |
Select text to the absolute end |
Shift+Alt+Left |
Select column symbol-by-symbol to the left |
Shift+Alt+Right |
Select column symbol-by-symbol to the right |
Shift+Alt+Up |
Select column upwards |
Shift+Alt+Down |
Select column downwards |
Shift+Ctrl+Alt+Left |
Select column word-by-word to the left |
Shift+Ctrl+Alt+Right |
Select column word-by-word to the right |
Shift+Alt+Home |
Select column to the beginning of line |
Shift+Alt+End |
Select column to the end of line |
Shift+Alt+PageUp |
Select column to the beginning of the page |
Shift+Alt+PageDown |
Select column to the end of the page |
Shift+Ctrl+Alt+Home |
Select column from the current cursor position to the beginning of the first line |
Shift+Ctrl+Alt+End |
Select column from the current cursor position to the beginning of the last line |
Ctrl+Up |
Scroll up one line with cursor position unchanged |
Ctrl+Down |
Scroll down one line with cursor position unchanged |
Alt+Down, Alt+Up |
Toggle case of a current word |
Ctrl+Alt+Up |
Toggle case to upper of a current selection or char |
Ctrl+Alt+Down |
Toggle case to lower of a current selection or char |
Ctrl+G+T |
Toggle folding |
Ctrl+G,Ctrl+F |
Collapse block at current line |
Ctrl+G,Ctrl+E |
Expand block at current line |
Ctrl+G,Ctrl+C |
Collapse/Expand block at current line |
Ctrl+G,Ctrl+M |
Collapse all blocks in the text |
Ctrl+G,Ctrl+P |
Expand all blocks in the text |
Ctrl+= |
Collapse/expand the nearest block |
Shift+Ctrl+B |
Jump to matching bracket (change range side) |
Shift+Ctrl+I |
Indent selected block |
Shift+Ctrl+U; Shift+Tab |
Unindent selected block |
Ctrl+/ |
Comment/uncomment selected block |
Ctrl+Space |
Show code completion |
Ctrl+Alt+Space |
Show character map |
Ctrl+Alt+P |
Show procedures |
Ctrl+Alt+N |
Show functions |
Ctrl+Alt+V |
Show views |
Ctrl+Alt+S |
Show SQL keywords |
Ctrl+Alt+T |
Show tables |
Ctrl+Alt+U |
|
Ctrl+Alt+G |
Show triggers |
Ctrl+Alt+E |
Show events |
Ctrl+Alt+Enter |
Select table in DB Explorer |
Shift+Ctrl+Space |
Show code parameters |
Ctrl+C; Ctrl+Ins |
Copy selection to Clipboard |
Ctrl+X; Shift+Del |
Cut selection to Clipboard |
Ctrl+V; Shift+Ins |
Paste Clipboard to current position |
Ctrl+Del |
Delete from cursor to the next word |
Ctrl+BkSp |
Delete from cursor to the end of the previous word |
Ctrl+B |
Delete from cursor to the beginning of the line |
Shift+Ctrl+Y |
Delete from cursor to the end of the line |
Ctrl+Y |
Delete the current line |
Ctrl+M; Enter; Shift+Enter |
Break line at current position, move caret to a new line |
Ctrl+Alt+I |
Insert Tab char |
Shift+Ctrl+R |
Start macro recording |
Shift+Ctrl+P |
Play macro |
Alt+End |
Skip misprint |
Ctrl+Alt+End |
Skip all misprints |
Alt+Home |
Correct all misprints |
F5 |
Toggle breakpoint |
Shift+F5 |
Enable breakpoint |
Ctrl+F1 |
Show original help |
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 |