This reporting view lists every referential constraint twice, once from each side, so that the relations of a table can be listed whichever side it is on. The constraints that refer to a table are listed under the table as "Used by Referential Constraints". It is read-only; the constraints themselves are maintained under [[Invantive Studio/Repository/Applications/Referential Constraints|Referential Constraints]]. The referential constraints that refer to the table of banks: ![[20261004-studio-referential-constraint-usages.png]] ## Fields The details show the referential constraint itself, with these fields: - "Name": Name of the referential constraint. - "Role Code": Code of the role. - "Sort Order": Numeric value that determines the ordering of the records in this table in a drop-down box. - "From Application Code": Code of the application of the referring table. - "From Table Code": Code of the referring table. - "From Table Column Name": Name of the referring column. - "From Role Label": Label of the role on the source table, always plural. - "To Application Code": Code of the application of the referred table. - "To Table Code": Code of the referred table. - "To Table Column Name": Name of the referred column. - "To Role Label": Label of the role on the target table, always singular. - "Create": Whether the referential constraint will be created. - "Display": Whether the constraint will be shown. - "On Delete Category": What should happen to the referring rows when the referred row is deleted; recorded in the repository, not applied by the generation in release 27.0. - "Documentation": Documentation on the referential constraint. Up to and including release 27.0 these fields read "Application Code", "Table Code", "Table Column Role From Name" and "Role Label from" for the referring side, and "Application Code", "Table Code", "Table Column Role To Name" and "Role Label to" for the referred side.