Archives of the TeradataForum

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

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

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>>