Online Documentation for SQL Manager for InterBase/Firebird

SQL Manager shortcuts


Database management

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

 

Database objects management

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

 

SQL Manager tools

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

Open Execute Script Editor

Shift+Ctrl+L

Open Localization Editor

Ins

Add a new table subobject (the subobject type depends on the current tab selection)

 

Data Grid

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

 

Print Data View

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