OraFAQ Forum: Client Tools » Toad--how to find table name based on FK column name

Home » SQL & PL/SQL » Client Tools » Toad--how to find table name based on FK column name (Toad 9.6.1.1)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Toad--how to find table name based on FK column name [message #406363]

Wed, 03 June 2009 11:31

bws93222
Messages: 13
Registered: April 2009

Junior Member

In Toad, when I'm looking at a (described) table with a FK field, how can I find the name of that table to which the FK points? Thx.

[Updated on: Wed, 03 June 2009 11:41]

Report message to a moderator

Re: Toad--how to find table name based on FK column name [message #406380 is a reply to message #406363]

Wed, 03 June 2009 13:57

andrew again
Messages: 2572
Registered: March 2000

Senior Member

F4 on the table name to bring up Describe window, then see Referential tab.

Report message to a moderator

Re: Toad--how to find table name based on FK column name [message #406395 is a reply to message #406380]

Wed, 03 June 2009 16:07

bws93222
Messages: 13
Registered: April 2009

Junior Member

This doesnt always seem to provide correct info. It works on some tables but on others, when I do that on a table with a field name that beginds FK_, there is no parent or child table listed for it. Am I missing something?

[Updated on: Wed, 03 June 2009 16:28]

Report message to a moderator

Re: Toad--how to find table name based on FK column name [message #406396 is a reply to message #406395]

Wed, 03 June 2009 16:30

andrew again
Messages: 2572
Registered: March 2000

Senior Member

It's quite possible to have FK named columns that have no associated FK constraint. View the constraints tab. FK contraints are of type "Referential integrity". These ones are represented on the Referential tab.

[Updated on: Wed, 03 June 2009 16:31]

Report message to a moderator