Skip to main content
Level 3
November 18, 2024
Solved

Schema

Hello , Can someone please explain "integrity"  and its possible values in easy way with example if possible .

 

  • integrity (optional): referential integrity of the occurrence of the source table to the occurrence of the target table.
    Possible values are:

    • define: it is possible to delete the source occurrence if it is no longer referenced by a target occurrence
    • normal: deleting the source occurrence initializes the keys of the link to the target occurrence (default mode), this type of integrity initializes all foreign keys
    • own: deleting the source occurrence leads to the deletion of the target occurrence
    • owncopy: the same as own (in case of deletion) or duplicates the occurrences (in case of duplication)
    • neutral: no specific behavior

Thanks in Advance

Manoj_Kumar
Manoj_KumarAccepted solution
Community Advisor
November 21, 2024

Hello @at7140 

 

Here is the Chatgpted version answer of your question with examples.

 

https://chatgpt.com/share/673e880b-f204-800d-b028-683cb1ed0221

Manoj  | https://themartech.pro

2 replies

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
November 21, 2024

Hello @at7140 

 

Here is the Chatgpted version answer of your question with examples.

 

https://chatgpt.com/share/673e880b-f204-800d-b028-683cb1ed0221

Translate
Manoj  | https://themartech.pro
Sukrity_Wadhwa
Level 4
January 17, 2025

Hi @at7140,

Was the given solution helpful to resolve your query? Do let us know. In case the given solution was helpful, then kindly choose it as the 'Correct Reply'.

Thanks!

Translate
Sukrity Wadhwa