Table Relationships

[jeremydevries]

Is there another way to see the relationships between all tables other than looking at the schema?

In other words, I would like to be able to determine all the referencing tables and referenced by tables of a table from within a script, and then take appropriate action within the script.

[Deepak Kumar5 · Accepted solution]

"Dictionary Entries" may help here.

First get list of all field (tables) having type reference.

Then check the reference table and again from Dictionary Entries get the column name of that references table whose Display = true

[jeremydevries]

Thank you! I believe you have given me what I need.