Post reply

Display the columns in Alphabetical order in 2005 Management Studio?

  • December 12, 2008 at 1:37 pm

    #128359

    I have a monster itemmstr table with 403 columns in it. When I look at this table in Management studio, the columns are not displayed in alphabetical order. If I am searching for a column, it is very hard to find it as the columns are not sorted. I checked the sys.all_columns sys view and figured that these columns are being displayed in column_id sort order. How can I change the way these columns are displayed to alpphabetical sort order? Thanks for your help.

  • December 12, 2008 at 1:45 pm

    #911904

    You can't change the sort order in the Object Explorer, but while the column folder in Object Explorer is highlighted, you can sort the column names in the Object Explore Detail Tab.

  • December 12, 2008 at 2:44 pm

    #911927

    That helps. Thanks a lot.

  • July 8, 2013 at 7:16 am

    #1630427

    Awesome. I had the same problem. Thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply