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

Take a look at the code for the reindex utility on my website... www.waynemyers.com