Schema

[at7140]

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_ · Accepted solution]

Hello @at7140 

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

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

[Sukrity_Wadhwa]

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!