Hi gang,
I've got a little "fix" program to apply updates to the client's databases, so that I don't have to go onsite just to make a teeny little change to a field/table.
One of the changes that I already applied was changing an index from a canditate index to regular index (by using ALTER TABLE ... DROP UNIQUE TAG ...) However, I now need to add another "fix" and would like to use the same program, skipping changes that have already been done (since I don't know if they have applied the fix yet ... I send them the EXEs and fixes, it's up to them to stick it on their servers).
The question is: how can I tell what the index type is? If I can tell that the index in the table in question has already been changed to a regular index, I obviously will not apply the "fix" a second time. I have not been able to find a command that can tell me that ... anybody know if there is one? If not, any suggestions as to how I can tell the index type so that I don't have to re-index unncessarily?
TIA,
Bonnie