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

テーブル固有の情報

SELECT

Salesforce 本製品 では、クエリを実行するためにTableName によるフィルタリングが必要です。

次に例を示します。

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。

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