<budget_name>!REMOVE_CYCLE_START_ACTION

Removes the user-defined action that is triggered when the budget cycle restarts.

See also:

<budget_name>!SET_CYCLE_START_ACTION, <budget_name>!GET_CYCLE_START_ACTION

语法

<budget_name>!REMOVE_CYCLE_START_ACTION()

返回

返回一个 VARCHAR 值，指示周期起始操作是否已成功移除。

访问控制要求

要为预算调用此方法，需要具备以下权限和角色：

  • ADMIN instance role for the budget instance.
  • 对包含预算实例的数据库和架构的 USAGE 权限。

For more information, see Budgets roles and privileges.

使用说明

Calling this method does not return the object. Because of this, you can’t use method chaining to call another method on the return value of this method. Instead, call each method in a separate SQL statement.

示例

Remove the cycle-start action from budget my_budget in schema budget_db.sch1:

CALL budget_db.sch1.my_budget!REMOVE_CYCLE_START_ACTION();