Active Query Builder support area

Programmatically specify Primary and Foreign Key fields

Avatar

Hello.  I am using the Delphi edition of AQB to write queries against Actian Pervasive database.
When adding a table to the querybuilder, I do not see the primary key indicator against PK field(s) as I do when querying SQL Server databases.  I guess this is to with limitations of Pervasive and the way you gather schema metadata?
Is there a way to programmatically specify what fields in the table are PKs?  Similar to the way aliases are defined.
Also - Is there an indicator for Foreign Key fields?  This would make it easier for end users to do table joins.
If so, same question: Is there a way to programmatically specify what fields in the table are Foreign Keys?