Get List of All Stored Procedures and Tables from Database in SQL Server

Now I will explain how to get all tables and stored procedures in database using SQL Server.

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