sys.procedures - Listing All Stored Procedures in SQL Server

Q

How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL?

✍: FYIcenter.com

A

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 FyiCenterData;
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)

 

Using Stored Procedures in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-01-05, 238👍, 0💬