Reporte de Tables e Indices
CASE b.indid
WHEN 0 THEN 'NO CLUSTERED INDEX'
WHEN 1 THEN 'CLUSTERED INDEX'
ELSE 'NONCLUSTERED INDEX'
END
from sysobjects a, sysindexes b
where a.type = 'U'
and a.id = b.id
and b.indid >= 0
and b.indid <255
and (b.status & 64)=0
order by a.name,b.indid