Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to expand active file tab names in SQL Management Studio?

Is there anyway I can expand the names of any query tabs I have open in SQL Server Management Studio? It's almost impossible to navigate them properly if I have more than five open.

like image 931
larryq Avatar asked Dec 31 '09 23:12

larryq


People also ask

How do I view more tabs in SSMS?

To toggle between several opened query windows of SSMS, use the Ctrl+TAB combination.

How do you give a tab space in SQL query?

We can use the following ASCII codes in SQL Server: Char(10) – New Line / Line Break. Char(13) – Carriage Return. Char(9) – Tab.

What is CTRL L in SSMS?

Typing CTRL+L executes either the selected text in the Query Editor window (or all the statements in the window if nothing is selected) and displays the execution plan. 2 comments. Rich Text Editor, edit-comment-body-91079.


1 Answers

You can shorten the display in each tab under Tools -> Options -> Text Editor -> Editor Tab and Status Bar.

I would suggest turning off "Include Login Name" and "Include server name" for starters, see if that helps.

Setting these:

SSMS Options Window

Shortens the tab from:

SSMS Tabs before

to:

SSMS Tabs after

like image 110
womp Avatar answered Sep 22 '22 08:09

womp