See SYS(2021) - Filtered Index Expression
>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.
--sb--