how to delete the data record which it has foreign key?

HI, There,

how to delete the data record which it has foreign key?

Many Thanks, 

Jack

Hi Jack,

You need to delete the record firstly from the child table to delete in a parent table.

Please refer : https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Data_Modeling/Entity_Relationships/Delete_Rules

For better understanding.


regards,

amreen

Hi,

You need to configure the delete rules in the table for that foreign key:

That property can be Protect (you can't delete the associated record), Delete (associated record is deleted) and Ignore (the associated record stays in the database).

This property needs to be treated with careful. This have impact in DB performance and in data integrity. 

I advise you to check the link that Amreen mention.


Hope this can help.



Best regards,

Ricardo