SAP SE
Consistency check for foreign key definition

Abstract:

A system includes reception of a request to check a foreign key definition associated with a database table, determination of a first foreign key relation of the foreign key definition, determination of whether the database table is a foreign key relation table identified in the first foreign key relation, and, if the database table is the foreign key relation table identified in the first foreign key relation, determine whether a data type of a foreign key field identified in the first foreign key relation is identical to a data type of a check table field identified in the foreign key relation, and return a first result associated with the first foreign key definition based on the determination of whether the data type of the foreign key field identified in the first foreign key relation is identical to the data type of the check table field identified in the foreign key relation. If the database table is not the foreign key relation table identified in the first foreign key relation, determine whether the data type of the foreign key field identified in the first foreign key relation is identical to the data type of the check table field identified in the foreign key relation, and determine whether the foreign key field is a runtime field of a runtime structure, and return a second result associated with the first foreign key relation based on the determination of whether the data type of the foreign key field identified in the first foreign key relation is identical to the data type of the check table field identified in the foreign key relation, and the determination of whether the foreign key field is a runtime field of a runtime structure.