View Procedure via nuosql

 

Q&A

{question}

Is there a nuosql command to view created stored procedures?

{question}

{answer}

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 code executed by the stored procedure.

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

Documentation for the SHOW command

Documentation for SYSTEM.PROCEDURES

Documentation for SYSTEM.PROCEDURECOLUMNS

{answer}

Have more questions? Submit a request

Comments