.show 函数.show function(s)
列出当前所选数据库中存储的所有函数。Lists all the stored functions in the currently-selected database. 若要仅返回一个特定函数,请参阅 .show function。To return only one specific function, see .show function.
.show functions.show functions
.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 functions。For 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. |
备注
- 如果该函数不存在,将返回错误。If the function does not exist, an error is returned.
- 需要数据库用户权限。Requires database user permission.
示例Example
.show function MyFunction1
名称Name | parametersParameters | 正文Body | 文件夹Folder | DocStringDocString |
---|---|---|---|---|
MyFunction1MyFunction1 | ()() | {StormEvents | limit 100}{StormEvents | limit 100} | MyFolderMyFolder | 简单演示函数Simple demo function |