469,600 Members | 2,393 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,600 developers. It's quick & easy.

Show Stored Procedure (version 5)

Hey Gang,

Playing around with stored procedures in version 5 (I am giggling like
a child, I am so excited about it).

Anyway, anyone know if there is a way, yet, to describe the procedure
once it is already created in the db? I see in the sp.test the
create,call,drop. Can we "desc" or "show"?

Thanks,
Rob Mazur
Jul 19 '05 #1
1 9527
Hey use this

mysql> SHOW CREATE PROCEDURE SPNAME;
It shows you the statement used to create the procedure

Happy coding
Irfan
Jun 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Michael | last post: by
4 posts views Thread by Rhino | last post: by
2 posts views Thread by Kent Lewandowski | last post: by
2 posts views Thread by Dino L. | last post: by
reply views Thread by SOI_0152 | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.