trying to get the partition table names .Queried dbc.indices WHERE indextype ='Q' with databasename = 'XXXX' .
Queried dbc.indexconstraints where databasename = 'XXXX' (constraintstype ='Q') for constrain text . where 'XXXX' refer to the same database .
The table name count between two query is not matching . any idea why ?
there are two possible reasons:
Btw, you should use IndicesV instead of Indices, which is deprecated and might not work correctly in TD14.10.
Additionally dbc.PartitioningConstraintsV returns more details than dbc.IndexConstraintsV.