Check FOR() command :) BTW, I have an application written, which does exactly that (compare table structure and indexes with DataDict and IndxDict definitions).
>To check whether a certain table needs to be upgraded (for fast updating of database structure), I want to find out if any field has changed, and if any index has changed, among others. I compare structures of two tables at a time.
>
>For instance:
>
>Candidate() tells me whether an index is candidate.
>
>Primary() tells me whether an index is a primary key.
>
>
>Is there a function to tell me what the filter expression is?
>
>TIA, Hilmar.
If it's not broken, fix it until it is.
My Blog