Tutorial :Remove dbo. schema prefix from SQLServer (2005) Management Studio's Object Explorer



Question:

I'd like to remove the dbo prefix from the Object Explorer so I can press the S key and go to the tables that begin with S; having dbo there is irritating (to me).

I have searched on the net and there was an answer at that other site that said I should use F7 in the summary tab, but I couldn't find a summary tab, and pressing F7 in the Object Explorer didn't work for me.


Solution:1

you can't in the Object Explorer, but the Object Explorer Details doesn't prefix the dbo.


Solution:2

I just found out you can enter, for example, dbo.f, and it navigates to the first table that starts with f.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »