sys.procedures - Listing All Stored Procedures in SQL Server


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



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;

SELECT * FROM sys.procedures;
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)


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

EXECUTE - Executing Stored Procedures in SQL Server

Using Stored Procedures in SQL Server Transact-SQL

⇑⇑ SQL Server Transact-SQL Tutorials

2017-01-05, 5992🔥, 0💬