Archives of the TeradataForum

Message Posted: Thu, 24 Jan 2002 @ 15:52:18 GMT

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

By "recursive", I assume you mean that some rows contain primary keys that appear as foreign keys in other rows because of a natural hierarchy (e.g. an employee has a manager who is also an employee). Are you asking (1) do we have tables where that happens to be true, although the database doesn't know about it, or (2) do we have tables in which that relationship is enforced by Teradata via REFERENCES constraints?

On my system, the answer to (1) is yes, to (2) no. If you are using Visual Explain, however, the QCD database does have a few tables with RI constraints -- e.g., statstep.

--wgr

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