title: soft referential integrity in teradata
body: <p>I am trying to define a referential integrity constraint in TD. But its throwing the following error. </p>
  
  <pre><code>alter table table_name 
      add constraint FK_site_part 
      foreign key (Oem_Site_Cd,Oem_Part_Nr) 
      references with no check option 2ndtabe_name (Site_Cd,Oem_Part_Nr);
  </code></pre>
  
  <pre>
   *** Failure 3976 Incorrect referential constraint definition.
                  Statement# 1, Info =0
   *** Total elapsed time was 1 second.`
  </pre>
  
  <p>could you please help me out with it. Moreover these tables do not have UPI defined, is that the reason for the above error.</p>