How to navigate foreign key relationships using the dictionary views?
I am implementing a CUBRID integration for jOOQ, and I wonder how I can discover foreign key relationships using the dictionary views. Using the following query, I can discover foreign key columns:
select k.class_name, k.index_name, k.key_attr_name from db_index i join db_index_key k on i.index_name = k.index_name and i.class_name = k.class_name where is_foreign_key = 'YES' order by k.class_name, k.index_name, k.key_order
Now, how can I discover which columns (or which primary key) is referenced?