Purpose
Renames an existing SQL procedure.
Required Privileges
You must have DROP privileges on the procedure to be renamed and the appropriate CREATE privileges on its containing database or user.
Syntax
Example
The following request renames the get_region_xsp procedure to emp.
RENAME PROCEDURE get_region_xsp TO emp;