How to Rename a Procedure in Redshift database

Below is the sql command to rename a stored procedure where proc_name is the name of the procedure and datatype1, datatype2, datatype3 are the datatypes of arguments and new_proc_name is the new name of the procedure.

ALTER PROCEDURE proc_name(datatype1, datatype2, datatype3,..) RENAME TO new_proc_name;

See also  How to drop a group in Redshift database

Leave a Reply

Your email address will not be published. Required fields are marked *