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