"DROP PROCEDURE" - Dropping an Existing Procedure in SQL Server

Q

How To Drop an Existing Stored Procedure in SQL Server Transact-SQL?

✍: FYIcenter.com

A

If you have an existing procedure that you don't want to use it anymore, you should delete it from the SQL Server by using the "DROP PROCEDURE" statement as shown in the tutorial example below:

USE FyiCenterData;
GO

DROP PROCEDURE datetime;
GO
Command(s) completed successfully.

SELECT * FROM sys.procedures;
GO
Name       object_id   schema_id   type type_desc           
---------- ----------- ----------- ---- --------------------
Hello      1621580815  1           P    SQL_STORED_PROCEDURE
date       1653580929  1           P    SQL_STORED_PROCEDURE

(2 row(s) affected)

Stored procedure "datetime" is no longer in the database.

 

Creating Stored Procedures with Statement Blocks in SQL Server

sys.procedures - Listing All Stored Procedures in SQL Server

Using Stored Procedures in SQL Server Transact-SQL

⇑⇑ SQL Server Transact-SQL Tutorials

2017-01-05, 1443🔥, 0💬