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

Syntax

SYSTEM$SHOW_BUDGETS_IN_ACCOUNT()

Returns

The function returns the following elements in a JSON object:

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.

Usage notes

The results include budgets for which the role executing the function has been granted any privileges.

Examples

The following example retrieves the budgets in the account:

SELECT SYSTEM$SHOW_BUDGETS_IN_ACCOUNT();