Post reply

query to find index on a column

  • October 8, 2012 at 4:36 pm

    #268197

    Is there a way i can find all the indices on a given column?

  • October 8, 2012 at 5:10 pm

    #1546974

    Sure. The catalog views involved are sys.indexes, sys.index_columns and sys.columns (and maybe sys.tables)

    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

  • October 10, 2012 at 1:17 am

    #1547493

    Hi,

    If u want queried for indexes....

    select name from sysindexes where object_id in (select object_id from systables or syscolumns)

    Go

  • October 10, 2012 at 1:29 am

    #1547497

    sysindexes and syscolumns are deprecated, should not be used any longer, will be removed from a future version of SQL Server. The replacements are sys.indexes and sys.columns.

    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

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

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