How to find number of stored procedures, tables ,functions present in a Database

Question

How to find number of stored procedures, tables ,functions present in a Database?

Please help me finding the above.

Answer 1

select count(*) 
from DatabaseName.information_schema.routines 
where routine_type in ('PROCEDURE', 'FUNCTION', 'TABLE')

Answer 2

You can use sys.Tables for the tables, sys.procedures for stored procedures and this answer for functions.

Answer 3

Simply

SELECT COUNT(*) FROM sysobjects WHERE xtype IN ('u', 'p', 'fn')

Hope this helps.