"Ed" <Ed@discussions.microsoft.com> wrote in message
news:8726E2FF-9853-4269-AD12-CD23B61CC85D@microsoft.com...
> hi,
> Is that possible I can use Information_Schema to find out all the index
> name(s) in the table???
> So far I have looked at all Information_Schema, but no luck and I have to
> use sp_helpindex.
>
> Thanks for any help
>
> Ed

"Ed" <Ed@discussions.microsoft.com> wrote in message
news:8726E2FF-9853-4269-AD12-CD23B61CC85D@microsoft.com...
> hi,
> Is that possible I can use Information_Schema to find out all the index
> name(s) in the table???
> So far I have looked at all Information_Schema, but no luck and I have to
> use sp_helpindex.
>
> Thanks for any help
>
> Ed

"Louis Davidson" <dr_dontspamme_sql@hotmail.com> wrote in message
news:edSfxVYEFHA.1264@TK2MSFTNGP12.phx.gbl...
> Nope. Indexes are not part of the information_schema. What do you mean
by
> "index names in the table"? Do you mean all indexes on a table:
>
>
> select name as index_name,
> index_col(object_name(id), indid, 1) as column1,
> index_col(object_name(id), indid, 2) as column2 --and so on
> from sysindexes
> where id = object_id('client_dim')
> and indid <> 0 --if there is no clustered index, the heap shows up
here.
>
> look up INDEXPROPERTY for ways to eliminate other indexes.
>
> --
> --------------------------------------------------------------------------
--
> Louis Davidson - drsql@hotmail.com
> SQL Server MVP
>
> Compass Technology Management - www.compass.net
> Pro SQL Server 2000 Database Design -
> http://www.apress.com/book/bookDisplay.html?bID=266
> Blog - http://spaces.msn.com/members/drsql/
> Note: Please reply to the newsgroups only unless you are interested in
> consulting services. All other replies may be ignored :)
> "Ed" <Ed@discussions.microsoft.com> wrote in message
> news:8726E2FF-9853-4269-AD12-CD23B61CC85D@microsoft.com...
> > hi,
> > Is that possible I can use Information_Schema to find out all the index
> > name(s) in the table???
> > So far I have looked at all Information_Schema, but no luck and I have
to
> > use sp_helpindex.
> >
> > Thanks for any help
> >
> > Ed
>
>