TableRelationships
Lists relationships in the specified table.
Table Specific Information
Select
The Salesforce add-in 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 child table that is related to the specified TableName in the input. | |
| RelationshipName [KEY] | String | The name of the relationship. | |
| Field | String | The field the relationship is associated on. Found in the ChildsObject. | |
| ParentObject | String | The parent object in the relationship. This is the same as the input TableName. | |
| DeprecatedAndHidden | Boolean | Boolean indicating if the relationship is deprecated and now hidden. | |
| CascadeDelete | Boolean | Boolean stating if this entity is deleted, does the child object also get deleted. |
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 name of the table to retrieve relationship information from. |