SYSFOREIGNKEY system table
1012
check_on_commit (Y/N) Indicates whether INSERT and UPDATE
commands should wait until the next COMMIT command to check if foreign
keys are valid. A foreign key is valid if, for each row in the foreign table, the
values in the columns of the foreign key either contain the NULL value or
match the primary key values in some row of the primary table.
nulls (Y/N) Indicates whether the columns in the foreign key are allowed
to contain the NULL value. Note that this setting is independent of the nulls
setting in the columns contained in the foreign key.
role The name of the relationship between the foreign table and the
primary table. Unless otherwise specified, the role name will be the same as
the name of the primary table. The foreign table cannot have two foreign
keys with the same role name.
remarks A comment string.
To Next Page
Loading...