Post reply

Indexes not shown in sys.objects

  • September 21, 2016 at 8:06 am

    #329956

    Hi,

    A SQL 2008 R2 database has 1 table with 2 indexes (clustered & non-clustered) - these are not listed when running the query below:

    SELECT *

    FROM [sys].[objects]

    Both indexes have the "Use index" option checked.

    Any ideas why they do not show?

    MattF

  • September 21, 2016 at 8:13 am

    #1902180

    Correct, indexes don't show up in sys.objects. You'll find indexes in sys.indexes (they're not considered objects like tables, procedures, constraints, etc are)

    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 2 posts - 1 through 1 (of 1 total)

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