In sql server management studio we have shortcut keys to execute operations Following are the main keyboard shortcut keys to work with sql server management studio.
Open New Query Window (Ctrl + N)
Shortcut key to open new query window in sql server management studio is Ctrl + N. It will open new key query window in current connection.
Execute Highlighted Query (Ctrl + E)
If want to execute highlighted or selected query in sql server management studio shortcut key is Ctrl + E.
Toggle between Open Tabs (Ctrl + Tab)
If we want to toggle or switch between opened tabs in sql server management studio shortcut key is Ctrl + Tab. It will help us to move between opened tabs easily.
Show / Hide Result Pane (Ctrl + R)
By using Ctrl + R shortcut key we can show / hide result pane of executed query. We can easily make full screen by hiding / closing result pane using shortcut key Ctrl + R.
Display Estimated Execution Plan (Ctrl + L)
If we want to show execution plan for queries which we are executing shortcut key is Ctrl + L. If we use Ctrl + L key combinations automatically it will show estimated execution plan for current executed queries.
Go to Particular Line (Ctrl + G)
If you want to go to particular line of query or get line number of query which we placed cursor shortcut key is Ctrl + G. By using this shortcut key we can easily get line numbers of query code in sql server management studio.
Cancel Execution of Query (Alt + Break)
By using Alt + Break shortcut key we can stop execution of query in sql server management studio.
0 comments:
Post a Comment
Note: only a member of this blog may post a comment.