SQL Server Foreign Key Update And Delete (Cascading Referential Integrity)
1/08/2019
View:
535
|
What is Cascading Referential Integrity? When a user tries to delete a key (column) on which an existing foreign key is based, that is called "Cascading Referential Integrity". Prerequisites to understand this are: - Create tables
- Add primary and foreign keys to those tables
- Add default constraints
Example Let us understand this by an example of two tables - tblDepartment and tblEmployee
CHI TIẾT - READ MORE
|