How to insert the record in child table without using - Drop Foreign Key and Parent Key Violation
In this Video we are going to learn below details:
can we drop FK?
2 options: we can drop or we can disable FK
when we enable the constraint with novalidate , it will not check any old data, but the constraint will work for any new records and validate the parent child relationship. after enable no validate, rule will work for new records not for old records.