Soft Referential Integrity

Database
Enthusiast

Soft Referential Integrity

Hi,
Can anyone tell me whether is there any difference in the soft referential integrity constraints in V2R5 vs V2R6?
Besides, does soft RI also involve additional internal maintenance like regular RI ?

Thanks.
3 REPLIES
Senior Apprentice

Re: Soft Referential Integrity

No and no :-)

There's a lot of info about that in the DDL manual: Create Table

Dieter
Enthusiast

Re: Soft Referential Integrity

Soft RI is just an indication that there is a PK-FK relation between the columns and is not implemented at TD side.

But having it would help in cases like Join processing etc.

It is expected that this will be enforced outside the Database.

Refer the manual for more details.

Regards,
Annal T
Enthusiast

Re: Soft Referential Integrity

Thank you all for the info.