HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Display table names in titles in SQL Server Management Studio

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqltitlesnamesmanagementstudioserverdisplaytable

Problem

Does anyone know how to get SQL Server Management Studio to display the Table names in the Title. Right now they are next to useless and every time I need to look at a table I have to reopen it.

In the good old days I used to use to Enterprise Manager and that was much more useful.

I found Brent Ozars article here, and the corresponding entry in Options... doesn't seem to be anything useful in there. Maybe a 3rd Party Product?

Solution

No, there is no way to make Management Studio do that. You've opened a query window, and you can customize what is displayed there, but table name is not one of the choices. After all, a small number of queries involve only one table. And think about these questions:

  • If you add another query to that window, what should the title become?



  • If you change the query it produced to be a join, what then?



  • If you've saved the query as some file, should the table name override the name you gave?



These questions are rhetorical, since the functionality is not possible anyway, but there are many other technical considerations that go far beyond right-clicking a table and saying SELECT TOP...

SSMSBoost seems to give you some control over these things, but I don't see table name as being an option here either (probably for the same technical challenges I raised in my bullets).

Context

StackExchange Database Administrators Q#55307, answer score: 4

Revisions (0)

No revisions yet.