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