Schema | Community
Skip to main content
Level 3
November 18, 2024
Solved

Schema

  • November 18, 2024
  • 2 replies
  • 498 views

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

Best answer by _Manoj_Kumar_

Hello @at7140 

 

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

 

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

2 replies

_Manoj_Kumar_
Community Advisor
_Manoj_Kumar_Community 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

     Manoj     Find me on LinkedIn
Sukrity_Wadhwa
Community Manager
Community Manager
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!

Sukrity Wadhwa