Display all the Tables and Stored Procedures in a database

Use this query to get all the tables and stored procedures in a database

USE DBNAME
GO
SELECT * FROM Sys.Objects
WHERE Type IN ('U', 'P')
ORDER BY type_desc


'U' denotes UserTables and
'P' denoted Stored Procedures