The RENAME PROCEDURE can be used to rename a stored procedure database object name to a new name. The user must have DROP PROCEDURE privilege on the stored procedure or on the database containing it and also CREATE PROCEDURE privilege on the same database. A stored procedure cannot be renamed across databases, only within the same database.

The syntax for RENAME PROCEDURE is:

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status

Teradata Topics