Testing for the Existance of Table Indexes

[rick]

Does anybody know if it's possible to test for the existance of a table
index? I am looking to write VB code that will try and find corrupted
indexes for several tables and automaticaly fix them. I have most of it
written except for the part that actually tests it. I am using multiple
CREATE/DROP INDEX SQL statements for each table index.

Usually a compact/repair will delete damaged indexes and I run this every
morning before running maintenance on my db. So I am trying to prevent extra
long run times by automaticaly repairing damaged (deleted) indexes. Any help
is greatly appreciated.

TIA.
Rick

 

[RJ]

If you are referring to Sql Server table indexes the best way to retrieve a
current index list is through the Master stored Procedure sp_helpindex. But
your question refers to compact/repair that suggests it's a Jet Database
question.