SQL Server Performance

Find index for Table column

Discussion in 'SQL Server 2005 General Developer Questions' started by a011010, Dec 22, 2009.

  1. a011010 New Member

    Hi,how can i found particular table's column has index or not
  2. FrankKalis Moderator

    You could query the sys.index_columns to find out.
    < pseudocode >
    SELECT ...
    FROM sys.indexes I
    JOIN sys.index_columns C ON ..
    WHERE OBJECT_NAME(I.object_id) = < your table name >
    </ pseudocode >
  3. satya Moderator

  4. Madhivanan Moderator

    orEXEC
    sp_helpindex 'your_table'

Share This Page