Hi,
my client enforced Foreign Key Relationship to the same table in DB2 database. is it usefull?.
Let me know your thought.
Ravi
Printable View
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