Bookshelf Home | Contents | Index | PDF |
Configuring Siebel eBusiness Applications > Configuring Links > About the Cascade Delete PropertyThe Cascade Delete property determines whether a child record is deleted when the parent record is deleted. Take special precautions when determining this property. If set incorrectly, it may cause data integrity issues or orphaned records. The Cascade Delete property can be set to the following values:
Cascade Delete is not available for many-to-many links. With a many-to-many link, Siebel applications will automatically delete the intersection record but will leave the child record intact, as it may have other parents. When you delete a record which is pointed to by foreign keys of other tables, the references to it may or may not be deleted. If those references are not deleted, the user is left with row IDs which point to nonexistent records. In the case of multi-value groups, sometimes these foreign keys will be converted to say "No Match Row Id." |
Configuring Siebel eBusiness Applications |