Post reply

doubt on indexes

  • November 14, 2008 at 5:22 am

    #94095

    Hi everybody,

    🙂

    Please tell me how to list out the indexes in a database, on which table and which column the index is created.

    Thanks

  • November 14, 2008 at 5:34 am

    #898496

    nageswara.dhaveji (11/14/2008)

    Hi everybody,

    🙂

    Please tell me how to list out the indexes in a database, on which table and which column the index is created.

    Thanks

    to check the table Employee, use this

    sp_help employee

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • November 14, 2008 at 5:53 am

    #898503

    I think You are looking for something like:

    select

    Object_Name( Object_Id)

    , *

    from sys.indexes

  • November 14, 2008 at 9:11 am

    #898694

    sp_helpindex for indexes on a table, or use sys.indexes and sys.index_columns to get all of the indexes in the DB

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 16, 2008 at 11:17 pm

    #899174

    Thanks to all. That servers my requirement.

    Thanks once again :Whistling: :satisfied:

    Nagesh

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

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