Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 19 Oct 2005 @ 09:45:19 GMT


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


Subj:   Identify Referenced columns
 
From:   sivakumar

Hai All,

Create references key in same table as below.

Ex:

     create table test(sno int primary key not null,sname varchar(20) unique
     not null,dname char(20) check (dname in('VALYD','SECURE')),mgr int
     REFERENCES sno,deptno smallint)

Can you provide how to identify References key using queries?

When i am trying to insert the data into the table, application throws an error message like"5312 Aborted due to a non-valid reference index on test.

Can you provide how to insert the data into the table?

Let me know in case of any issues and clarifications.


With Regards,

Siva Kumar.



     
  <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