Silver Posted September 17, 2011 Share Posted September 17, 2011 I’d appreciate if one would advise how to amend the name and code of a created stored procedure, if feasible, or drop (delete) it. Link to comment Share on other sites More sharing options...
Silver Posted September 17, 2011 Author Share Posted September 17, 2011 I figured out how to drop a procedure. It goes like this: DROP PROCEDURE name; No arguments or parenthesis used. I am still searching for how to amend a procedure, rather than deleting it, and if one has a ready answer, pls. share it Link to comment Share on other sites More sharing options...
Larry Posted September 19, 2011 Share Posted September 19, 2011 As far as I know, you can't amend an existing procedure. Instead you drop it and recreate it. Link to comment Share on other sites More sharing options...
Recommended Posts