Here is the answer,
SELECT CAST(SO.[name] AS CHAR(20)) AS TableName
, CAST(SI.[name] AS CHAR(30)) AS IndexName
, CAST(SC.[name] AS CHAR(15)) AS ColName
, CAST(ST.[name] AS CHAR(10)) AS TypeVal
, CASE WHEN (SI.status & 16)<>0 THEN 'Yes' ELSE 'No' END AS ClusteredIndex
FROM
SYSOBJECTS SO INNER JOIN SYSINDEXES SI INNER JOIN SYSINDEXKEYS SIK
ON SIK.[id] = SI.[id]
AND SIK.indid = SI.indid INNER JOIN SYSCOLUMNS SC INNER JOIN SYSTYPES ST
ON SC.xtype = ST.xtype ON SIK.[id] = SC.[id]
AND SIK.colid = SC.colid
ON SO.[id] = SI.[id]
WHERE SO.xtype = 'u'
AND SI.indid > 0
AND SI.indid < 255
AND (SI.status & 64)=0
ORDER BY
TableName
, IndexName
, SIK.keyno
Regards....
Sujit
Main Topics
Browse All Topics
by: AustinSevenPosted on 2004-09-10 at 05:39:52ID: 12025807
sp_helpindex 'tablename'
AustinSeven