Post reply

Find out columns included into a index

  • April 16, 2009 at 7:13 am

    #130127

    Hello to all,

    I was trying to understand how I can see the columns included in an index on sql server 2005. Someone may help me?

    Thanks

  • April 16, 2009 at 7:24 am

    #978798

    Do you have SQL Server Management Studio? If so, use the Object Explorer to drill down to the indexes on your table, then right-click on the index you are curious about and select Properties.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • April 16, 2009 at 7:39 am

    #978817

    Perfect!

    Thanks a lot.

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

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