Categories:

System functions (System Information)

SYSTEM$SHOW_BUDGETS_IN_ACCOUNT

Returns the budgets in the account for which you have access privileges.

See also:

CREATE BUDGET

语法

SYSTEM$SHOW_BUDGETS_IN_ACCOUNT()

返回

该函数在 JSON 对象中返回以下元素：

Column NameData TypeDescription
DATABASETEXTName of the database to which the budget instance belongs.
SCHEMATEXTName of the schema to which the budget instance belongs.
CREATED_ONNUMBERUTC timestamp when the budget instance was created.
IDNUMBERInternal/system identifier for the budget instance.
CURRENT_VERSIONTEXTBudget class version used to create the budget instance.
COMMENTTEXTComment for the budget instance.
NAMETEXTName of the budget instance.

使用说明

结果包括函数执行角色对其具有任何权限的预算。

示例

以下示例检索账户中的预算：

SELECT SYSTEM$SHOW_BUDGETS_IN_ACCOUNT();