if i want to delete records in a relational database. how does it help me if i edit the relationships first?How does editing the relationships in a database help when deleting records?
Not exactly sure what you mean be ';edit the relationship'; but if you are using referential integrity then you are ensuring that anything using the target record as a reference is deleted before the target record is removed.
For example in a customer order database. You would delete the customer's orders first before deleting the customer information record. That way you are not left with orders but no customer information.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment