If you need to delete a stored procedure in TSQL. You can use a built-in function called DROP. It is recommended that you perform a check to see if the stored procedure you want to delete does exist in the sysobjects table.
Let says we have a stored procedure called NewUser.
Here is the full TSQL query to perform a deletion of the stored procedure in SQL Server.
IF EXISTS ( SELECT * FROM dbo.sysobjects WHERE Id = object_id(N'NewUser') AND OBJECTPROPERTY(id, N'IsProcedure') = 1 ) DROP PROCEDURE NewUser GO