Categories:

System functions (System Information)

SYSTEM$GET_ALL_REFERENCES¶

遍历一个引用的所有关联，并返回有关这些关联的信息。

语法

SYSTEM$GET_ALL_REFERENCES('<reference_name>', [, <include_details> = True | False ])

实参

必填

'reference_name'

引用的名称。

{include_details = True | False }

Determines the type of information returned by the function. For more information, see 返回.

返回

• If the include_details parameter is set to True, returns a VARCHAR containing a JSON object that contains an array of the following name/value pairs:

  Copy codeExpand code block

  {
    "alias": "<value>",
    "database": "<value>",
    "schema": "<value>",
    "name": "<value>"
  }

  Show lessSee more

  Scroll to top

其中：

• alias：系统为引用生成的别名。

• database: The parent database name of the consumer object, if the object resides in a database. Otherwise, null.

• schema: The parent schema of the consumer object, if the object resides in a schema. Otherwise, null.

• name：使用者对象的名称。

• If the include_details parameter is set to False, returns an array of system-generated aliases:

  • 如果引用未与对象关联，则返回空列表。
  • If the reference, is associated with an object, returns all associations for a multi-valued references.
  • 如果引用为单值引用，则返回 0。