Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete in child table should update parent modidate
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00760229
Message ID:
00760243
Views:
14
>>You can use delete trigger on CartContent table.
>>
>Thanks, just wanted to make sure, there is no other way. I'll try to write it tomorrow... Would it only need to handle updates, since I set cascading deletes?

There's another way. You can issue UPDATE command on Cart table every time you delete from CartContent table but it doesn't seem like a right way to do that.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform