Where are Foreign Keys Stored in the Database?

[fitzsimmons92]

Hello all.  I have a bunch of table objects that I am relating to each other and defining foreign keys.  I want to run a report that shows me the PK-FK relationship, like custID = customer_id.  Can you help me please?

What I have tried so far:
1. Printing the name the connector. For some reason, that name is blank in t_connector even though the properties show it with a name. 
2. I found in t_attribute, the isOrdered and isConnected field seems to identify the PKs and FKs, but I can't relate that the specific column in the other table.

Is the PK and FK relationship explicitly stored in a table that I have just overlooked?

[qwerty]

Too long ago, but AFAIR you have to peek into the tagged values (and I can't remember whether is was t_objectproperties or one of the t_xxxtag tables).

q.

[Richard Freggi]

This is what I use for my queries, seems to work for me

Code: [Select]

CASE WHEN t_attribute.IsOrdered = 1 THEN 'Y' ELSE '' END,--PK
CASE WHEN t_attribute.IsCollection= 1 THEN 'Y' ELSE '' END,--FK
CASE WHEN t_attribute.AllowDuplicates = 1 THEN 'Y' ELSE '' END,-- NN; Weird but correct
CASE WHEN t_attribute.AllowDuplicates = 1 or t_attribute.IsStatic = 1 THEN 'Y' ELSE '' END,--Unique NEED TO ADD OTHER UNIQUE FROM CONSTRAINTS

What FK references what PK is stored in t_connector table and its tags I think

[Geert Bellekens]

And there is an operation that corresponds to the FK constraint.

Geert