⟩ How To List All Stored Procedures in the Current Database using MS SQL Server?
If you want to see a list of stored procedures in your current database, you can use the system view, sys.procedures as shown in this tutorial exercise:
USE GlobalGuideLineDatabase;
GO
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
datetime 1669580986 1 P SQL_STORED_PROCEDURE
(3 row(s) affected)
