EMS logo

Produkt Navigation

SQL Manager for SQL Server

Unsere Partnerschaften

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

Online Bedienungsanleitung

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