Post reply

clustered index in what information_schema?

  • December 20, 2005 at 2:20 pm

    #90258

    In what information_schema I can find a clustered index?

  • December 20, 2005 at 2:52 pm

    #610736

    They aren't in the information schema views. You'll need to query sysindexes, using 'Where IndID = 1' for clustered index.

  • December 20, 2005 at 2:56 pm

    #610737

    Thank you.  Do you know if this is still valid in SQL 2005?

  • December 20, 2005 at 3:22 pm

    #610739

    You can use sysindexes for the time being, but you probably want to query against the view sys.indexes. The column type_desc tells you what type of index it is. Clustered indexes can be found where type_desc = 'CLUSTERED' if that's what you are looking for.

    K. Brian Kelley
    @kbriankelley

  • December 21, 2005 at 7:52 am

    #610841

    Yes, thank you.

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

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