Archives of the TeradataForum

Message Posted: Fri, 08 Mar 2002 @ 06:22:01 GMT

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

Hi all,

I have a question on Circularly referencing tables.

Is the following relation possible or should the database prevent such a relation from being created?

CREATE TABLE tab1(a int not null primary key references tab2(a)); // a forward reference

CREATE TABLE tab2(a int not null primary key references tab1(a)); // a circular reference

Restrictions by the above is that no inserts,updates,deletes,drop can be performed.

So should such a relation be allowed?

Narayan.

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