开发者

Many to Many Relationship Keys

开发者 https://www.devze.com 2023-01-12 04:54 出处:网络
I have 2 entity objects (table1 and table3) with a many to many relationship via an intermediary table (ta开发者_高级运维ble2) containing only the 2 PK/FK keys.

I have 2 entity objects (table1 and table3) with a many to many relationship via an intermediary table (ta开发者_高级运维ble2) containing only the 2 PK/FK keys.

With the relationship manager I can view the end points of the relationship (table1 and table3) but I need to know the name of "table2" and the names of the PK/FK fields in table2.

Any ideas?

Thanks


What DBMS are you using? If mysql, do a "SHOW TABLES" to get the tables listed, and then "DESCRIBE TABLENAME" to list the fields in TABLENAME

0

精彩评论

暂无评论...
验证码 换一张
取 消