Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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
Sign in to Comment

Related questions

Is there a python (scipy) function to determine parameters needed to obtain a target power?
Get yesterday's date in Python, DST-safe
unsafe link in angular
NSAttributedString initWithHTML incorrect character encoding?
Ruby 2.0 iconv replacement
Exclude folder from github
Why alias_method fails in Rails model
sbt clear screen command
height:100% not working in Internet Explorer
Why glibc's fclose(NULL) cause segmentation fault instead of returning error?
Class library does not recognize CommandManager class
PreferenceFragment background color

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!