Archives of the TeradataForum

Message Posted: Thu, 06 Feb 2003 @ 15:34:15 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Assuming that your foreign keys have the same name in the different tables and that any columns with the same name mean the same thing, then you could query DBC.Columns to see in what tables a particular column exists. With some work you could identify all your relationships this way.

	<Prev	Next>		<<First	<Prev	Next>	Last>>