Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Identifying foreign keys in queryman or winddi
From:   Jason Fortenberry

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020