语法格式
SHOW FUNCTION STATUS
说明
显示已经创建成功的函数的状态。
示例
显示已经创建成功的函数的状态。
gbase> SHOW FUNCTION STATUS;
+--------+----------+----------+-----------+-------------------+
| Db | Name | Type | Definer | Modified |
+--------+----------+----------+-----------+-------------------+
| ssbm | hello | FUNCTION | root@% | 2013-10-22 17:18:21 |
| test | fn_count | FUNCTION | root@% | 2013-10-22 17:56:17 |
| test | hello | FUNCTION | root@% | 2013-10-22 17:22:37 |
+--------+----------+----------+-----------+-------------------+
+---------------------+---------------+-----------+
| Created | Security_type | Comment |
+---------------------+---------------+-----------+
| 2013-10-22 17:18:21 | DEFINER | |
| 2013-10-22 17:56:17 | DEFINER | |
| 2013-10-22 17:22:37 | DEFINER | |
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 801
+---------------------+---------------+-----------+
+----------------------+-----------------------+--------------------+
| character_set_client | collation_connection | Database Collation |
+----------------------+-----------------------+--------------------+
| utf8 | utf8_general_ci | utf8_general_ci |
| utf8 | utf8_general_ci | utf8_general_ci |
| utf8 | utf8_general_ci | utf8_general_ci |
+----------------------+-----------------------+------------------+
3 rows in set