.show functions.show functions

列出当前所选数据库中存储的所有函数。Lists all the stored functions in the currently-selected database. 若要仅返回一个特定函数,请参阅 .show functionTo return only one specific function, see .show function.

.show functions

需要数据库用户权限Requires database user permission.

输出参数Output parameter 类型Type 说明Description
名称Name StringString 函数的名称。The name of the function.
parametersParameters StringString 函数所需的参数。The parameters required by the function.
正文Body StringString (零个或多个)let 语句,后跟有效的 CSL 表达式,该表达式在函数调用时求值。(Zero or more) let statements followed by a valid CSL expression that is evaluated upon function invocation.
文件夹Folder StringString 用于 UI 函数分类的文件夹。A folder used for UI functions categorization. 此参数不会更改调用函数的方式。This parameter doesn't change the way the function is invoked.
DocStringDocString StringString 用于 UI 目的的函数说明。A description of the function for UI purposes.

输出示例Output example

名称Name parametersParameters 正文Body 文件夹Folder DocStringDocString
MyFunction1MyFunction1 ()() {StormEvents | limit 100}{StormEvents | limit 100} MyFolderMyFolder 简单演示函数Simple demo function
MyFunction2MyFunction2 (myLimit: long)(myLimit: long) {StormEvents | limit myLimit}{StormEvents | limit myLimit} MyFolderMyFolder 带参数的演示函数Demo function with parameter
MyFunction3MyFunction3 ()() { StormEvents(100) }{ StormEvents(100) } MyFolderMyFolder 调用其他函数的函数Function calling other function

.show function.show function

.show function MyFunc1

列出存储的某个特定函数的详细信息。Lists the details of one specific stored function. 有关所有函数的列表,请参阅 .show functionsFor a list of all functions, see .show functions.

语法Syntax

.show function FunctionName.show function FunctionName

输出Output

输出参数Output parameter 类型Type 说明Description
名称Name StringString 函数的名称。The name of the function.
parametersParameters StringString 函数所需的参数。The parameters required by the function.
正文Body StringString (零个或多个)let 语句,后跟有效的 CSL 表达式,该表达式在函数调用时求值。(Zero or more) let statements followed by a valid CSL expression that is evaluated upon function invocation.
文件夹Folder StringString 用于 UI 函数分类的文件夹。A folder used for UI functions categorization. 此参数不会更改调用函数的方式This parameter doesn't change the way function is invoked
DocStringDocString StringString 用于 UI 目的的函数说明。A description of the function for UI purposes.

备注

示例Example

.show function MyFunction1
名称Name parametersParameters 正文Body 文件夹Folder DocStringDocString
MyFunction1MyFunction1 ()() {StormEvents | limit 100}{StormEvents | limit 100} MyFolderMyFolder 简单演示函数Simple demo function