INDEXES ON A TABLE

Hi,
How can I find out the indexes on a particular table. which data dictionary
table I nshould query?
In enterprise manger there is no object called indexes.
pls help.
Thanks,
RetnaHi,
sp_helpindex <table_name>
sp_help <table_name> (This will list Indexes and all the other information
related to that table)
Indexes will be stored in a system table : sysindexes
Thanks
Hari
MCDBA
"RETNA" <anonymous@.discussions.microsoft.com> wrote in message
news:454888B6-A08B-4930-A3D1-83431F1CE5B1@.microsoft.com...
> Hi,
> How can I find out the indexes on a particular table. which data
dictionary table I nshould query?
> In enterprise manger there is no object called indexes.
> pls help.
> Thanks,
> Retna|||Is Enterprise Manager - tell "Design..." on table and then look onto toolbar
buttons - one of them is responsible for showing you indexes list (actually
it's not only SHOW you index list but allow you to add new indexes and
modify'n'delete existing ones)
"RETNA" <anonymous@.discussions.microsoft.com> wrote in message
news:454888B6-A08B-4930-A3D1-83431F1CE5B1@.microsoft.com...
> Hi,
> How can I find out the indexes on a particular table. which data
dictionary table I nshould query?
> In enterprise manger there is no object called indexes.
> pls help.
> Thanks,
> Retna|||Thanks for your help|||Thank you Alex for your help.