August 18, 2011 at 1:56 pm
I have a silly question.
In SSMS, in the Object Explorer, the databases, tables, indexes, views, users, roles, etc are all listed alphabetically.
Except for columns. Those are listed in the order they are in the actual table. I can see the benefit of having it ordered that way, but I can also see the benefit of sorting the columns alphabetically. And I would even like it that way half the time.
Is there a setting somewhere that I missed?
Edit: found a workaround using the Object Explorer Details tab. Any way to make it sortable in the main Object Explorer?
August 18, 2011 at 2:20 pm
Not that I know of.
If I need the columns in a particular order, I query sys.columns, and Order By name or whatever.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 18, 2011 at 2:56 pm
I do it much the same as Gus.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply