SQL Server - Get List of All Stored Procedures from Database in SQL Server

Here I will explain simple SQL Query to get list of all stored procedures from SQL Server database or How to get list of all stored procedures in SQL Server Database or How to Get list of all tables in SQL Serverdatabase.


Use SampleDb

Select sys.Procedures

--------------------------------------------------------------------------------------------

Use SampleDb

Select Sys.Tables