Home / Software / Tips and Tricks / How to drop stored procedure if it exists before creating the stored procedure?

How to drop stored procedure if it exists before creating the stored procedure?

Updated:  07/13/2010 11:07 AM
Author:  Shiju Mathews

Status:    Resolved.


While design phases it is advantage to add some script to drop stored procedure if it exists. ’ Alter Procedure’ is an alternate way to accomplish this. Use the following script to for this task.



Where
  • HumanResource is the schema name
  • SalaryList is the stored procedure name

    This script will first delete the stored procedure if it exist, and then create the stored procedure.
  •