SQL Server Management Studio Keyboard Shortcuts

Hi Friends,

SQL Server Management Studio offers a wide variety of Keyboard Shortcuts. By default, it uses the Standard scheme, with keyboard shortcuts based on Microsoft Visual Studio. A second scheme, called SQL Server 2000, closely resembles the tools from SQL Server 2000, in particular the keyboard shortcuts from the Query Analyzer. In a few cases, SQL Server Management Studio cannot offer the keyboard shortcuts from Query Analyzer. To change the keyboard scheme or add additional keyboard shortcuts, on the Tools menu, click Options. Select the desired keyboard scheme on the Environment, Keyboard page.

Microsoft has provided a complete Bible of Keyboard Shortcuts @ http://msdn.microsoft.com/en-us/library/ms174205.aspx

These are few shortcuts worth to mention:

IntelliSense Shortcuts

Action Standard
List members CTRL+SPACE or CTRL+J
Complete word ALT+RIGHT ARROW
Parameter information CTRL+SHIFT+SPACE
Refresh Local Cache CTRL+SHIFT+R
Jump between syntax pairs CTRL+]

Text Manipulation in Code Editor Shortcuts

Action Standard
Change the selected text to lowercase CTRL+SHIFT+L
Change the selected text to uppercase CTRL+SHIFT+U
Move selected lines to the left on tab stop SHIFT+TAB

Log Viewer Shortcuts

Action Standard
Refresh F5
Move between the Select logs pane and the Log file summary pane F6
Move to the Log file summary pane ALT+S
Load a new log CTRL+SHIFT+L
Export a log CTRL+SHIFT+E
Filter a log CTRL+SHIFT+F
Search in a log CTRL+SHIFT+S

Replication Monitor Shortcuts

Action Standard
Refresh F5
Open a detail window from a grid ENTER

For More Shortcuts visit: http://msdn.microsoft.com/en-us/library/ms174205.aspx



Sarabpreet Anand

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on Twitter  |  Follow me on FaceBook


Leave a Reply

Your email address will not be published.