Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 02 Apr 2002 @ 23:34:09 GMT

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

Subj:   Re: Alter table and RI
From:   Robin Grothaus

If referential constraints are added to an already populated table, the system automatically creates the _0 table to hold any violations found during creation. After the constraint is created no future violations will be allowed.

Remember that referential constraints are not copied when using arcmain to copy 1 environment to another (Prod to Test), also when restore is used this must be followed by a "revalidate references" command.

  <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