The commands "show create procedure" and "show create function" are used to check on the contents of either a stored procedure or function, respectively. Simply append the name of the SP or function after the corresponding command like so:
show create procedure spGetData;
Note that you should have privileges for the said routine in order to display the contents of the SQL object. Otherwise, it would return NULL.
No comments:
Post a Comment