morrySnow commented on code in PR #1871:
URL: https://github.com/apache/doris-website/pull/1871#discussion_r1925287202
##########
docs/sql-manual/sql-statements/function/SHOW-FUNCTIONS.md:
##########
@@ -24,67 +24,97 @@ specific language governing permissions and limitations
under the License.
-->
-
-
-
## Description
-View all custom (system-provided) functions under the database. If the user
specifies a database, then view the corresponding database, otherwise directly
query the database where the current session is located
+View all custom and system provided functions under the database.
-Requires `SHOW` permission on this database
+## Syntax
-grammar
+```sql
+SHOW [ FULL ] [ BUILTIN ] FUNCTIONS [ { IN | FROM } <db> ] [ LIKE
'<function_pattern>' ]
+```
+## Varaint Syntax
```sql
-SHOW [FULL] [BUILTIN] FUNCTIONS [IN|FROM db] [LIKE 'function_pattern']
+SHOW GLOBAL [ FULL ] FUNCTIONS [ LIKE '<function_pattern>' ]
```
-Parameters
+## Required Parameters
->`full`: Indicates the detailed information of the display function
->`builtin`: Indicates the functions provided by the display system
->`db`: database name to query
->`function_pattern`: parameter used to filter function names
+**1. `<function_pattern>`**
-grammar
+> Matching pattern rules used to filter function names
-```sql
-SHOW GLOBAL [FULL] FUNCTIONS [LIKE 'function_pattern']
-```
+## Optional Parameters
+
+**1. `FULL`**
+
+> FULL is an optional parameter.
+>
+> This parameter indicates the detailed information about the function.
+
+**2. `BUILTIN`**
-Parameters
+> BUILTIN is an optional parameter.
+>
+> This parameter indicates that the functions provided by the system need to
be displayed
->`global`: Indicates it means that the show function is a global function
->`full`: Indicates the detailed information of the display function
->`function_pattern`: parameter used to filter function names
+**3. `<db>`**
-**Note: the "global" keyword is only available after v2.0**
+> db is an optional parameter.
+>
+> This parameter indicates the query under the specified database
-## Example
+## Return Value
+
+| 列名 | 说明 |
Review Comment:
```suggestion
| Column | Description |
```
##########
docs/sql-manual/sql-statements/function/SHOW-FUNCTIONS.md:
##########
@@ -24,67 +24,97 @@ specific language governing permissions and limitations
under the License.
-->
-
-
-
## Description
-View all custom (system-provided) functions under the database. If the user
specifies a database, then view the corresponding database, otherwise directly
query the database where the current session is located
+View all custom and system provided functions under the database.
-Requires `SHOW` permission on this database
+## Syntax
-grammar
+```sql
+SHOW [ FULL ] [ BUILTIN ] FUNCTIONS [ { IN | FROM } <db> ] [ LIKE
'<function_pattern>' ]
+```
+## Varaint Syntax
```sql
-SHOW [FULL] [BUILTIN] FUNCTIONS [IN|FROM db] [LIKE 'function_pattern']
+SHOW GLOBAL [ FULL ] FUNCTIONS [ LIKE '<function_pattern>' ]
```
-Parameters
+## Required Parameters
->`full`: Indicates the detailed information of the display function
->`builtin`: Indicates the functions provided by the display system
->`db`: database name to query
->`function_pattern`: parameter used to filter function names
+**1. `<function_pattern>`**
-grammar
+> Matching pattern rules used to filter function names
-```sql
-SHOW GLOBAL [FULL] FUNCTIONS [LIKE 'function_pattern']
-```
+## Optional Parameters
+
+**1. `FULL`**
+
+> FULL is an optional parameter.
+>
+> This parameter indicates the detailed information about the function.
+
+**2. `BUILTIN`**
-Parameters
+> BUILTIN is an optional parameter.
+>
+> This parameter indicates that the functions provided by the system need to
be displayed
->`global`: Indicates it means that the show function is a global function
->`full`: Indicates the detailed information of the display function
->`function_pattern`: parameter used to filter function names
+**3. `<db>`**
-**Note: the "global" keyword is only available after v2.0**
+> db is an optional parameter.
+>
+> This parameter indicates the query under the specified database
-## Example
+## Return Value
+
+| 列名 | 说明 |
+| -- |------------|
+| Signature | Function name and parameter type |
+| Return Type | The data type of the value returned by the function |
+| Function Type | Type of function |
+| Intermediate Type | Intermediate result type |
+| Properties | Detailed properties of a function |
+
+## Access Control Requirements
+
+The user who executes this SQL command must have at least the following
permissions:
+
+| Privilege | Object | Notes |
+|:--------------|:---------|:--------------|
+| SHOW | Function | You need to have the show permission on this function |
Review Comment:
```suggestion
| SHOW_PRIV | Function | You need to have the show permission on this
function |
```
##########
docs/sql-manual/sql-statements/function/SHOW-CREATE-FUNCTION.md:
##########
@@ -24,43 +24,65 @@ specific language governing permissions and limitations
under the License.
-->
-
-
-
## Description
-This statement is used to display the creation statement of the user-defined
function
+This statement is used to show the creation statement of a user-defined
function
-grammar:
+## Syntax
```sql
-SHOW CREATE [GLOBAL] FUNCTION function_name(arg_type [, ...]) [FROM db_name]];
+SHOW CREATE [ GLOBAL ] FUNCTION <function_name>( <arg_type> ) [ FROM <db_name>
];
```
-illustrate:
-1. `global`: The show function is global
-2. `function_name`: The name of the function to display
-3. `arg_type`: The parameter list of the function to display
-4. If db_name is not specified, the current default db is used
+## Required Parameters
+
+**1. `<function_name>`**
+
+> The name of the custom function that you want to query for the creation
statement.
+
+**2. `<arg_type>`**
-**Note: the "global" keyword is only available after v2.0**
+> The parameter list of the custom function that needs to be queried for the
creation statement.
+>
+> Parameter list location you need to enter the data type of the location
parameter
-## Example
+## Optional Parameters
-1. Show the creation statement of the specified function under the default db
+**1.`GLOBAL`**
- ```sql
- SHOW CREATE FUNCTION my_add(INT, INT)
- ```
-2. Show the creation statement of the specified global function
+> GLOBAL is an optional parameter.
+>
+> If GLOBAL is set, the function is searched for globally and deleted.
+>
+> If GLOABL is not entered, the function is searched for in the current
database and deleted.
- ```sql
- SHOW CREATE GLOBAL FUNCTION my_add(INT, INT)
- ```
+**2.`<db_name>`**
-## Keywords
+> FROM db_name indicates that the custom function is queried from the
specified database
- SHOW, CREATE, FUNCTION
+## Return Value
-## Best Practice
+| Column | Instructions |
Review Comment:
```suggestion
| Column | Description |
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
