clustered index in what information_schema?

Question

clustered index in what information_schema?

jdalonzo

SSCrazy

Points: 2232
More actions
December 20, 2005 at 2:20 pm

#90258

In what information_schema I can find a clustered index?

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

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

PW-201837 SSC-Insane Points: 20805 More actions · Answer 1

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

jdalonzo SSCrazy Points: 2232 More actions · Answer 2

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

K. Brian Kelley SSC Guru Points: 114704 More actions · Answer 3

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

jdalonzo SSCrazy Points: 2232 More actions · Answer 4

jdalonzo

SSCrazy

Points: 2232

December 21, 2005 at 7:52 am

#610841

Yes, thank you.

clustered index in what information_schema?

Cookies on SQLServerCentral