Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prodigy2006
Yak Posting Veteran
66 Posts |
 Posted - 2009-01-24 : 14:36:42
|
| Might appear quite silly but I want to know what is a parent object, child object and when an object can be called orphan?Answers would be appreciated.Thanks,Sunny. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-25 : 05:04:39
|
| on what context? you mean in case of fk constraint?the table which has fk is child and table to which fk refers is parent.An object can be called orphan when the referred object/value doesn't exist any more. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-01-25 : 19:47:27
|
| It's anything within a hierarchy.Each entry apart for the top level (often considered to reference a single virtual parent) should have at least one referenced parent and may have one or more children.This may cause circular references where an entry is a decendant of itself.Often this is not allowed nor are refernces between branches - the hierarchy then becomes a tree.An orpan is just a non top level entry that has no parent.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2009-01-26 : 15:36:22
|
| Thanks a lot. |
|
|
|
|
|
|
Parent, Child objects