Hello again everyone!
I've been away for a while, but I've started working again and have a question I am hoping someone might be able to provide some feedback on.
I have a SQL database that has many relationships that utilize surrogate keys. These relationships (some of them) have cascading deletes, but in the SSMS I have been leaving Updates to "No Action." I don't think this is a problem, I never really thought about it, but wouldn't the only time you need cascading updates be if you have natural keys or surrogate keys that are not identities?
I don't even show the PK in the UI, it's not necessary and other than helping SQL, it serves no use to the user.
Thoughts on when you would use cascading updates or am I correct in my assumption?
I appreciate your input as always!
Cheers!