Index details

How do i retrive index details if i have table name and
column details..
I need index name,type ,whether composite ,if composite
what are the columns present..Have a look at sp_helpindex in BOL e.g. exec sp_helpindex 'Orders'
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:8b0e01c432ac$97bbaf80$a101280a@.phx.gbl...
> How do i retrive index details if i have table name and
> column details..
> I need index name,type ,whether composite ,if composite
> what are the columns present..
>|||Hi
INDEXPROPERTY ( table_ID , index , property )
<anonymous@.discussions.microsoft.com> wrote in message
news:8b0e01c432ac$97bbaf80$a101280a@.phx.gbl...
> How do i retrive index details if i have table name and
> column details..
> I need index name,type ,whether composite ,if composite
> what are the columns present..
>