Home » SQL & PL/SQL » Client Tools » Toad--how to find table name based on FK column name (Toad 9.6.1.1)
Toad--how to find table name based on FK column name [message #406363] Wed, 03 June 2009 11:31 Go to next message
bws93222
Messages: 27
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 Go to previous messageGo to next message
andrew again
Messages: 2574
Registered: March 2000
Senior Member
F4 on the table name to bring up Describe window, then see Referential tab.
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 Go to previous messageGo to next message
bws93222
Messages: 27
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 Go to previous messageGo to next message
andrew again
Messages: 2574
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

Re: Toad--how to find table name based on FK column name [message #406397 is a reply to message #406396] Wed, 03 June 2009 16:36 Go to previous messageGo to next message
bws93222
Messages: 27
Registered: April 2009
Junior Member
ok that was it--it said type: 'check' instead of 'referential integrity'--so for those FK fields, there is no associated table? Right?
Re: Toad--how to find table name based on FK column name [message #406400 is a reply to message #406397] Wed, 03 June 2009 17:18 Go to previous messageGo to next message
andrew again
Messages: 2574
Registered: March 2000
Senior Member
right, the FK field naming convention just helps to spot the designer's thoughts - only the real FK constraint enforces anything.
Re: Toad--how to find table name based on FK column name [message #406403 is a reply to message #406400] Wed, 03 June 2009 17:46 Go to previous message
bws93222
Messages: 27
Registered: April 2009
Junior Member
thx much!
Previous Topic: Oracle client compatibilty
Next Topic: spool format UTF8 in sqlplus9
Goto Forum:
  


Current Time: Sun Dec 21 04:26:55 CST 2014

Total time taken to generate the page: 0.07724 seconds