Skip to Content (Press Enter)
UserImage.jpg
Jack Bao
264Views
2Comments
how to delete the data record which it has foreign key?
Question

HI, There,

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

Many Thanks, 

Jack

0
0
28 Jan 2019
Copy Link
2021-10-17 12-36-16
Amreen Shaikh

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

2
0
28 Jan 2019
Copy Link
2021-03-05 13-56-11
Ricardo Pereira
 
MVP

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

0
0
28 Jan 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.