Deleting STORED PROCEDURE in Teradata

You can delete a stored procedure by DROP command.

Syntax:
DROP PROCEDURE procedure_name;


Example:
Assume you want to drop the SP_Employee procedure from the database.
The DROP PROCEDURE statement looks like this:
DROP PROCEDURE SP_Employee;