Option do not show schema names in SQL Server Management Studio
- by Jörgen Sigvardsson
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!