Published on: 09 Jan, 2021

How to delete a stored procedure in TSQL?

Tumblr Digg Google Plus

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

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.