Archives of the TeradataForum
Message Posted: Thu, 06 Feb 2003 @ 15:34:15 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|