Archives of the TeradataForum
Message Posted: Wed, 19 Oct 2005 @ 09:45:19 GMT
Create references key in same table as below.
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|