Hi everybody,
I'm changing structure of the table programmatically and I want to drop some columns (delete fields). The problem here, that I need to be sure, this field in not uses in any Index Expression (and Index Filter expression), otherwise I have an error. Therefore, I have to check, if field (call it FieldA) is used in Index Expression or Index Filter Expression and if it is, delete this tag as well.
The problem I see with this approach is: (in theory), suppose, I have fields called FieldA and FieldAB. I want to delete FieldA and leave FieldAB. If I would check Index Epr and Index Filter Expr for 'FieldA' $ IndexEpr, I'll find both cases (TagA & TagAB and delete both). This is the problem, associated with this idea. Therefore, when I re-create indexes, I will have to re-create one additional index (deleted by this code) and this would take time.
Do you have some suggestions regarding this problem? May be there is a better way?
Thanks a lot in advance.
If it's not broken, fix it until it is.
My Blog