How to 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.

Get List of Stored procedure names in database

USE SampleDB

SELECT * FROM SYS.PROCEDURES

Get List of table names in database

USE SampleDB

SELECT * FROM SYS.TABLES