system.relations

Advantage SQL Engine

Contains one row for each referential integrity constraint in the database.

Field Name

Field Type

Field Size

Description

Name

Character

200

Referential integrity constraint name.

RI_Primary_Table

Character

200

The name of the primary table.

RI_Primary_Index

Character

200

The name of the primary key used in the referential integrity constraint.

RI_Foreign_Table

Character

200

The name of the foreign table.

RI_Foreign_Index

Character

200

The name of the foreign key used in the referential integrity constraint.

RI_UpdateRule

ShortInt

2

The numeric representation of the update rule used by the referential integrity constraint.

RI_DeleteRule

ShortInt

2

The numeric representation of the deletion rule used by the referential integrity constraint.

RI_No_Pkey_Error

Memo

variable

The custom error message returned when a new foreign key value does not exist in the primary key.

RI_Cascade_Error

Memo

variable

The custom error message returned when a cascading update or delete fails.