Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSMS shortcut to navigate between open query windows

Tags:

I sometimes have a large amount of query windows open in SSMS 2008.

Is there a keyboard shortcut to navigate between open query windows? Go to previous/next open query window?

I know there is Ctrl+Tab that allows you to select a query window, but it's only helpful if you have named windows.

like image 688
Ewald Stieger Avatar asked Feb 28 '13 14:02

Ewald Stieger


People also ask

How do I switch between tabs in SSMS?

Ctrl + F6 will switch between two most recent tabs.

What is Ctrl L in SSMS?

To find this out, press CTRL+L to display the estimated query execution plan as shown below without actually running the whole query (in fact it runs for top 1 row).

What does Ctrl e do in SQL Server?

Ctrl + R should show/hide result pane. Ctrl + E should execute the query.


2 Answers

SSMS 2008

Ctrl+F6 will switch between two most recent tabs. And honestly, Ctrl+Tab / Ctrl+Shift+Tab work like next/previous except you have to hit Tab twice (you can ignore knowing what the name of the tab in the list is).

That said, have you considered upgrading to SQL Server 2012 Management Studio? A lot of its features are much more refined than the 2008 version (and you will still be able to manage your 2008 servers). A challenge you'll find here is what does "next" really mean? Since you can tear off tabs, split the UI, even move tabs onto different monitors, I think "next" and "previous" lose a little meaning unless you know what order they were opened in...

SSMS 2012

  • Ctrl+F6 will cycle through open tabs in the order they are displayed, and Ctrl+Shift+F6 will cycle in the reverse direction.
  • Ctrl+Tab / Ctrl+Shift+Tab will open a temporary window and allow you to cycle through open queries in the order they were last opened.
like image 151
Aaron Bertrand Avatar answered Dec 23 '22 04:12

Aaron Bertrand


the equivalent of Ctrl+Tab in browsers for SSMS would be Ctrl+Alt+PageDown for next tab and Ctrl+Alt+PageUp for previous tab.

like image 42
bridge_burner Avatar answered Dec 23 '22 04:12

bridge_burner