[stackoverflow] [progress Openedge Abl] Query To Find Primary Index For A Progress Table...

[Vel]

In the previous versions of Progress database (9.X, 10.X) the below query works fine to find the primary index of the table.

select "_index-name" from PUB."_index" in, PUB."_file" fi where fi."_file-name"='tableName' and in."rowid" =(select"_file"."_prime-index" from PUB."_file" fs where fs."_file-name"='tableName');

Now the rowid has been removed on progress v11.6, Is there any SQL query to fetch the primary index of a progress database table through ojdbc?

Continue reading...