Testing for the Existance of Table Indexes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top