-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|