How to create Foreign Key Constraint With ON UPDATE CASCADE in SQL Server - SQL Server Tutorial 79
SQL Server / T-SQL Tutorial Scenario:
In previous posts, we learn that if we have Foreign key Constraint with default setting and we try to update the value in column in Reference Table which is used as Reference Column in Foreign Key Constraint, we get error. We discussed multiple ways to handle the situation, please check this link.
Foreign Key Constraint does provide the option to set the Cascading action, we can create Foreign Key Constraint with Cascading Update.
If Update Cascading settings is used, when we update the value in Referenced Table , it will also update the value in parent table (Foreign Key Table) column.
Link to scripts used in SQL Server / TSQL Tutorial Video
http://www.techbrothersit.com/2016/04...
Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)
http://www.techbrothersit.com/