How to find the number of stored procedures, tables, functions present in the database

Question

How to find the number of stored procedures, tables, functions present in the database?

Please help me find 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 sys.Tables tables for stored procedures and this answer for functions.

Answer 3

Simply

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

Hope this helps.

Answer 4

 SELECT * FROM user_objects WHERE object_name LIKE 'proc%' .... 

Answer 5

 SELECT * FROM DB_Name.INFORMATION_SCHEMA.TABLES 

Answer 6

 SELECT * FROM sysobjects WHERE (xtype = 'p') 

You can get all the information from sysobjects