Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 24 Jan 2002 @ 15:52:18 GMT

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

Subj:   Re: Recursive table definitions
From:   Geoffrey Rommel

  Do any of you use recursive table definitions in Teradata?  

By "recursive", I assume you mean that some rows contain primary keys that appear as foreign keys in other rows because of a natural hierarchy (e.g. an employee has a manager who is also an employee). Are you asking (1) do we have tables where that happens to be true, although the database doesn't know about it, or (2) do we have tables in which that relationship is enforced by Teradata via REFERENCES constraints?

On my system, the answer to (1) is yes, to (2) no. If you are using Visual Explain, however, the QCD database does have a few tables with RI constraints -- e.g., statstep.


  <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: 15 Jun 2023