---

{ “title”: “DESC FUNCTION”, “language”: “en”, “description”: “Use the desc function tablevaluedfunction to obtain the schema information for the corresponding table-valued function.” }

Description

Use the desc function table_valued_function to obtain the schema information for the corresponding table-valued function.

Syntax

DESC FUNCTION <table_valued_function>

Required Parameters

<table_valued_function>

table_valued_function, the name of the table-valued function, such as CATALOGS. For a list of supported table-valued functions, please refer to the “Table-Valued Functions” section

Examples

Query the information of the table-valued function CATALOGS:

DESC FUNCTION catalogs();

The result is as follows:

+-------------+--------+------+-------+---------+-------+
| Field       | Type   | Null | Key   | Default | Extra |
+-------------+--------+------+-------+---------+-------+
| CatalogId   | bigint | No   | false | NULL    | NONE  |
| CatalogName | text   | No   | false | NULL    | NONE  |
| CatalogType | text   | No   | false | NULL    | NONE  |
| Property    | text   | No   | false | NULL    | NONE  |
| Value       | text   | No   | false | NULL    | NONE  |
+-------------+--------+------+-------+---------+-------+