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

Introduction

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 Server database.  

Get List of Stored procedure names in database

To get list of procedures in SQL Server we need to write the query like as shown below

USE SampleDB SELECT * FROM SYS.PROCEDURES

Get List of table names in database

To get list of tables in SQL Server we need to write the query like as shown below

USE SampleDB SELECT * FROM SYS.TABLES