SEMANTIC_RELATIONSHIPS 视图¶

此 Information Schema 视图为指定（或当前）数据库的语义视图中的每个关系显示一行。

列¶


列名称	数据类型	描述
`semantic_view_catalog`	VARCHAR	语义视图所属的数据库。
`semantic_view_schema`	VARCHAR	语义视图所属的架构。
`semantic_view_name`	VARCHAR	语义视图的名称。
`name`	VARCHAR	语义关系的名称。
`table_name`	VARCHAR	引用其他表的语义表的名称。
`foreign_keys`	ARRAY(VARCHAR)	引用其他表列的列的名称列表。
`ref_table_name`	VARCHAR	被引用的语义表的名称。
`ref_keys`	ARRAY(VARCHAR)	One of the following values: For relationships that represent range joins, an array that contains JSON-formatted strings for objects with the following keys: The `start_column` key specifies the name of the column that represents the start of the range. The `end_column` key specifies the name of the column that represents the end of the range. The `type` key is `RANGE`. For relationships that represent ASOF joins, an array that contains the following elements: The name of the column in the first table. A JSON object with the following fields: `column`: Name of the column in the second table. `type`：`ASOF`。 For other types of relationships, an array containing the name of the column in the other logical table in the relationship.