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

Table-Specific Information

SELECT

The Salesforce driver requires filtering on TableName in order to perform the query.

For example:

SELECT * FROM TableRelationships WHERE TableName = 'your_value'

Columns

Name	Type	References	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.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data 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.