Take the 2-minute tour ×

I love the fact that tree and list controls in Windows allows incremental searches. Just select a starting point, and type, and the control will select the best matching node for you.

This works in SSMS, but there's an annoying problem, especially so in the table node. SSMS prefixes all table names with the schema name and a dot. To make an incremental search here, I have to type 'dbo.', followed by whatever I'm searching for. Is there an option to turn off this table name representation in SSMS?

I hope I'm asking this on the right stack exchange site. If you feel it's off base, let me know!

share|improve this question

1 Answer 1

up vote 1 down vote accepted

As far as I am aware there is no way to customise this. If you have two objects named the same but in different schemas e.g. sales.person, hr.person then there would be no way to distinguish them.

I read yesterday about http://www.sqltreeo.com/wp/ which allows you to customise the tree hierarchy in SSMS. You may want to look in to that tool but I doubt it will let you do it either.

You can however right click and select Filter from the context menu, which is suspect is the closest you can get to this functionality.

share|improve this answer
I had not reflected on the fact that SSMS is actually implemented in a Visual Studio shell. As such, it's possible to extend it with add-ins, just like the product you linked to. This gave me an idea to google for SSMS and add-in. I found two really nice sites: ssmsaddins.codeplex.com and ssmstoolspack.com I'm going to accept your answer, because it led me to something usable (I found a quick-find add-in that looks promising!). Cheers! –  Jörgen Sigvardsson Nov 16 '11 at 12:08

Your Answer


