I want to develop a program that will delete indexes and rebuild them at any given time. I can scan the directory for the indexes but I do not know which table the indexes belong too without looking. And I want this program to automatically fire off at 6 am and 6 pm daily. In order to do this, I will have to have exclusive use of the tables understood. Anyone know how I can find out what indexes belong to which table?
Thanks in Advance.
J. Turner