tag:blogger.com,1999:blog-8712770457197348465.post1225057774224681102..comments2018-02-21T19:26:12.706-08:00Comments on Javarevisited: What is Referential Integrity in Database or SQL - MySQL Example TutorialJavin Paulhttps://plus.google.com/114528699166048052030noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8712770457197348465.post-1236190824882529162013-03-11T00:29:55.818-07:002013-03-11T00:29:55.818-07:00I&#39;ve one confusion. If we insert in to parent ...I&#39;ve one confusion. If we insert in to parent table without adding in to child table at the same time and deleting from child table. That would cause violation of Referential integrity?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-61956018453782928942013-01-08T19:22:07.632-08:002013-01-08T19:22:07.632-08:00Great examples. I have used foreign keys many time...Great examples. I have used foreign keys many times but never use referential integrity checks e.g. updating or deleting records in foreign key table. Your examples shows me how important CASCADE ON UPDATE and CASCADE ON DELETE can be. Would be great if you can share similar examples of Referential Integrity Constraint checks from MSSQL Server.Varronnoreply@blogger.com