ShotCuts in SQL Server

ShotCuts in SQL Server


2000 – Start->Run-> "isqlw" –To open a query analyzer in 2000

2005 – Start->Run-> "sqlwb" —To open SSMS in 2005 (Not Query analyzer For New Query use Alt+N)

2005 – Start->Run-> "ssmsee" —TO open SSMS in 2005 (Express Edition)

The most commonly used keyboard shortcuts in the SQL Server Management Studio (SSMS).

Start->Run-> and then SqlWb.exe to launch SQL Server Management Studio

Results in Grid
Ctrl + D

Change database
Ctrl + U

Results in Text
Ctrl + T

Execute Query
Ctrl + E or F5

Show/Hide Object browser
F8 (Auto Hide has to be enabled)

New Query Window
Ctrl + Q

New Query with New Connection
Ctrl + N (Then selecting SQL Server Query template)

Open a .SQL Script file
Ctrl + O

Full Screen
Shift + Alt + Enter

Parse the query
Ctrl + F5

Show/Hide Results Pane
Ctrl + R

Switch between query and results panes

Information about all the objects in the current database
Alt + F1


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: