View Procedure via nuosql



Is there a nuosql command to view the created stored procedures?



SHOW PROCEDURES will show all procedures defined in the current schema.

SHOW PROCEDURE procedure_name will show the IN/OUT parameters of the procedure.

Further information can be retrieved by querying the system table SYSTEM.PROCEDURES. For example, the "PROCEDURETEXT" field contains the actual text of the procedure as entered at the time of the CREATE PROCEDURE.

Further information about IN/OUT parameters can be retrieved by querying SYSTEM.PROCEDURECOLUMNS.

Documentation for the SHOW command

Documentation for SYSTEM.PROCEDURES



Have more questions? Submit a request