View Procedure via nuosql

 

Q&A

{question}

Is there a nuosql command to view the 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 actual text of the procedure as entered at the time of theCREATE 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