Many to Many Relationship 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