Archives of the TeradataForum
Message Posted: Fri, 08 Mar 2002 @ 06:22:01 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|