how to find index # and name in the same place

Hi,
I am wondering if anyone has a query handy for looking up the indexes
for a given table, that would show both the index name *and* the index
number in the output
Thanks muchtootsuite,
On SQL 2K:
select
o.name TableName
, i.indid IndexNumber
, i.name IndexName
from sysobjects o
inner join sysindexes i on o.id = i.id
order by o.name, i.indid
-- Bill
<tootsuite@.gmail.com> wrote in message
news:1168623613.741766.142850@.m58g2000cwm.googlegroups.com...
> Hi,
> I am wondering if anyone has a query handy for looking up the indexes
> for a given table, that would show both the index name *and* the index
> number in the output
> Thanks much
>|||Thanks much, this works on 2005 also
AlterEgo wrote:[vbcol=seagreen]
> tootsuite,
> On SQL 2K:
> select
> o.name TableName
> , i.indid IndexNumber
> , i.name IndexName
> from sysobjects o
> inner join sysindexes i on o.id = i.id
> order by o.name, i.indid
> -- Bill
> <tootsuite@.gmail.com> wrote in message
> news:1168623613.741766.142850@.m58g2000cwm.googlegroups.com...