CODEWITHSUNDEEP
sql-serverssms
Nathan Koop
Nathan Koop

Reputation: 25197

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

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.

Upvotes: 14

Views: 4326

Answers (2)

Gordon
Gordon

Reputation: 59

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

Upvotes: 5

KM.
KM.

Reputation: 103597

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

Upvotes: 13

Related Questions