Get all SP and Tables and Views from the Database

To get All Stored Procedures:

use [database_name]
SELECT * FROM sys.procedures;

To get All Tables:

select * from Database_name.information_schema.tables

To get All Views:

select * from Database_name.information_schema.views