Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 01 Jul 2002 @ 19:30:30 GMT

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

Subj:   Re: Object dependancies
From:   Summers, Scott

If you have referential integrity in place on your system than you can use these dictionary views to check for dependencies.

RI_Child_Tables V       F       1       DBC
RI_Distinct_Children    V       F       1       DBC
RI_Distinct_Parents     V       F       1       DBC
RI_Parent_Tables        V       F       1       DBC

However, if you don't have referential integrity in place you really cannot say what objects are functionally dependent on each other by looking at DBC. You must rely on your metadata and data model (assuming you have them documented) to determine actual dependencies.

  <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: 27 Dec 2016