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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-23 : 21:02:31
|
| Chris writes "I'm pretty new to SQL server and would like some information about cascading update (not delete) triggers. Suppose I have two tables, table1 and table2 and each have primary keys table1ID and table2ID respectively. table2 also has table1ID as a foreign key. Can I draw in the foreign key relationship in the diagrams and still be able to do cascading updates? Do you update the child first and then the parent or vice versa?" |
|
|
|
|
|
Cascading update triggers