For indexes there are 2 system tables: sys.indexes and sys.sysindexes. I'd like to know what are their differences. Both contain information about indexes then why they are separate?

Thanks in advance.

1 Answer 1


sys.sysindexes - is old and deprecated.

This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead.

you should use sys.indexes.

  • 1
    sys.indexes doesn't contain the same data as sys.sysindexes though.
    – Dai
    Dec 6, 2021 at 11:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.