Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

In SSMS, how do I change a SQL query window's tab name?

I want to know how to change the tab name of a SQL query window:

enter image description here

Instead of SQLQuery8.sql…Registry(sa(51)), I would like to have a custom caption.

If the query window has a very title, I can only open 3 windows at a time. I want to open more than 10 windows. So I need to change the query window's name to something very short, something like Q1, Q2, etc.

How can I change this?

like image 386
user3252014 Avatar asked Jul 09 '14 12:07

user3252014


People also ask

How do I change a tab character in SQL?

If you want to replace the tab with another character, such as a blank, you can use the TRANSLATE function.


1 Answers

In SSMS, go to Tools > Options > Text Editor > Editor Tab and Status Bar.

You can manage some options of tab text, as shown in the picture below.
(for example don't include db name, file name, login name and/or server name).

SQL Server Options

like image 154
Raphaël Althaus Avatar answered Sep 22 '22 08:09

Raphaël Althaus