GBase 8a MPP存储过程参考-2

ALTER {PROCEDURE | FUNCTION} <sp_name> [characteristic ...]

characteristic:

 SQL SECURITY { DEFINER | INVOKER }

  | COMMENT 'string'

1 row in set

gbase> ALTER PROCEDURE proc_count COMMENT 'new comment'；

Query OK, 0 rows affected

gbase> ALTER FUNCTION fn_count COMMENT 'new comment';

Query OK, 0 rows affected

DROP {PROCEDURE | FUNCTION} [IF EXISTS] <sp_name>