• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • Last Modified:

SQL 2017 ssms query windows tabs

SQL 2017 ssms
How do I just show table name or view name in a tab   when I'm designing a table or a view?            
   Instead of    -->Server Name\Instance Name \ Database Name \ Table Name  (See graphic)

I Have gone to Options\ Text Editor\ Editor tab and Status Bar and setting the "Tab Text" to False (see graphic) solved the problem with tabs where I am typing an SQL statement, however if I'm designing a table or a view I get
               -->Server Name\Instance Name \ Database Name \ Table Name  (See graphic)

Thanks in advance for any help.
LJGSQL_Options.png
0
LJG
Asked:
LJG
  • 3
  • 2
  • 2
2 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I don't think that's possible. The idea is for you to know at anytime in which database and schema are you working.
Just for curiosity, why is that so important for you?
0
 
LJGAuthor Commented:
Quite often I have 7 or 8 tabs open and I want to immediately go to tab 1 (a table for the sake of argument) and then go back to tab 7 (a View for the sake of argument.

It is SELDOM that I'm working with multiple Servers / Instances / Databases at the same time.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Imagine that you're changing a table in Production environment instead of in the Development environment. With the table name only you aren't able to know immediately in which environment you're working, right?
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Mark WillsTopic AdvisorCommented:
if in design mode you do get to see the full name across the very top
and if you hover over the tab, it does show the name...
or go to windows drop down...

otherwise, the actual name on the tab is predetermined.
the options you display are for the footer, not the header

You might be able to add extended properties to designpane but that will be *involved* and never tried it to expose a tab name.
0
 
Mark WillsTopic AdvisorCommented:
Well, apparently you are not alone - see if this helps : http://ssmsplus.codeplex.com/

If nothing else, it proves *something* can be done...

And, for a price, there is Mladen SSMSToolpack : http://ssmstoolspack.com/Features
0
 
LJGAuthor Commented:
Thanks so much for the info.

I will be looking at ssms addins (Some day)
0
 
Mark WillsTopic AdvisorCommented:
Please let us know what you end up doing. You have now aroused my curiosity...

Cheers, and Thanks,
Mark Wills
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now