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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)