Online Documentation for SQL Manager for InterBase/Firebird
SQL Manager shortcuts
Shift+Ctrl+R |
Register a InterBase/Firebird host using Register Host 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 |
F9 |
Execute a procedure |
Shift+Ctrl+F9 |
Debug a procedure |
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 Query Data Editor |
Shift+F12 |
Open a new instance of Query Data Editor |
Shift+Ctrl+M |
Open SQL Monitor |
Shift+Ctrl+S |
|
Shift+Ctrl+L |
Open Localization Editor |
Ins |
Add a new table subobject (the subobject type depends on the current tab selection) |
Ctrl+Shift+0 |
Set the selected column value to NULL |
Query Data and Execute 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 (Query Data 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 |
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+Q |
Save text as Favorite |
Shift+Ctrl+F |
Format SQL text using SQL Formatter |
Alt+<symbol> |
Switch to the query with <&symbol> in its name (Query Datacx` only) |
Ctrl+J |
Insert a keyboard template |
Shift+Ctrl+F |
Format SQL |
Ctrl+Alt+Left |
Switch to the next tab of Query Data |
Ctrl+Alt+Right |
Switch to the previous tab of Query Data |
Ctrl+Alt+PgUp |
Switch to the last tab of Query Data |
Ctrl+Alt+PgDown |
Switch to the first tab of Query Data |
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+Alt+Home |
Select column to the first char of line |
Shift+Alt+End |
Select column to the last char 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+G,Ctrl+F |
Collapse block at current line |
Ctrl+G,Ctrl+E |
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 |
Esc |
Collect marker (jump back) |
Shift+Esc |
Swap marker to current position |
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+Shift+Space |
Call a hint listing parameters for added procedures and UDFs |
Ctrl+Alt+Space |
Show character map |
Ctrl+Alt+P |
Show procedures |
Ctrl+Alt+V |
Show views |
Ctrl+Alt+T |
Show tables |
Ctrl+Alt+G |
Show triggers |
Ctrl+Alt+U |
Show UDFs |
Ctrl+Alt+Enter |
Show table in SQL Assistant |
Ctrl+Alt+M |
Show domains |
Ctrl+Alt+E |
Show generators |
Ctrl+Alt+X |
Show exceptions |
Ctrl+Alt+R |
Show roles |
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+T |
Delete from cursor to the next word |
Ctrl+BkSp |
Delete from cursor to the beginning of the 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+O,N |
Normal selection mode |
Ctrl+O,C |
Column selection mode |
Ctrl+O,L |
Line selection mode |
Ctrl+M; Enter; Shift+Enter |
Break line at current position, move caret to a new line |
Ctrl+Alt+I |
Insert Tab char |
F5 |
Toggle breakpoint |
Shift+F5 |
Enable/disable brakpoint |
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 |