EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

SQL Manager shortcuts


Database management:

 

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

 

 

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

Go to bookmark #<digit>

Ctrl+Q

Go to next 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

Save the script to an external file

Ctrl+F1

Show original help SQL Server Books Online

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

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

Shift+Ctrl+Space

Show code parameters

Ctrl+Alt+Space

Show character map

Ctrl+Alt+T

Show tables

Ctrl+Alt+V

Show views

Ctrl+Alt+M

Show synonyms

Ctrl+Alt+G

Show defaults

Ctrl+Alt+L

Show rules

Ctrl+Alt+H

Show users

Ctrl+Alt+A

Show assemblies

Ctrl+Alt+Y

Show UDTs

Ctrl+Alt+W

Show SQL keywords

Ctrl+Alt+N

Show SQL functions

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 current selection

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

Enter;

Shift+Enter

Break line at current position, move caret to a new line

Ctrl+Alt+I

Insert Tab char

Shift+Ctrl+P

Play macro

Shift+Ctrl+R

Start macro recording

Alt+End

Skip misprint

Ctrl+Alt+End

Skip all misprints

Alt+Home

Correct all misprints

 

 

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