MySQL Forums
Forum List  »  Newbie

Rename Stored Procedure Syntax
Posted by: Ruan de Villiers
Date: August 04, 2009 04:58AM

Hi All...

I am sitting with a situation where i need to Rename a stored Procedure and Not drop it. Reason for this is that i need it for a backup. I searched all over the web for a Example and all i can get is this darn "useless example"(for me)

ALTER {PROCEDURE | FUNCTION} sp_name [characteristic ...]

NAME newname
| COMMENT string

found at

In the first place this does not work for me it gives me an error.
can someone please just give me an example as to how to rename a Stored Procedure.

Options: ReplyQuote

Written By
Rename Stored Procedure Syntax
August 04, 2009 04:58AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.