ODBC Driver for Certinia

Build 25.0.9434

TableRelationships

Stores metadata about relationships between tables, defining parent-child object associations.

Columns

Name Type Description
ChildsObject [KEY] String The name of the child object or table that has a relationship with the specified parent table.
RelationshipName [KEY] String The API name of the relationship, typically used in relationship queries or joins.
Field String The field in the child object that establishes the relationship to the parent object.
ParentObject String The parent object that the child is related to. This matches the value of the input TableName.
DeprecatedAndHidden Boolean Indicates whether this relationship has been deprecated and is now hidden from general use.
CascadeDelete Boolean Indicates whether deleting the parent object will also automatically delete related child records.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
TableName String The table for which relationship metadata should be retrieved. Acts as the input for this view.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434