Refrential Intergrity in same table

Hi,
my client enforced Foreign Key Relationship to the same table in DB2 database. is it usefull?.
Let me know your thought.
Ravi

Depends, do it if have to.

rmiao,
will it make sense?

It does in some cases, for example Empoyee table

EMPID, MANAGER_ID

Since manager is also an employee, you have a self referencing table.

I saw that before in some application where parentID and ChildID will be on the same table.

It depends on the functionality of your app' and the approach you take for database design.

skhanal......

you beat me this time.


:D