Getting Database objects count using SQL SERVER 2008

• 
  Edit

Used to get objects count from database,

Select count(*) as Count 

, xtype from sysobjects group by xtype

Output:

Count xtype

30    IF

6   U 

3  SQ

1  AF

136  X 

4 FS

3 PC

1  D 

1348 P 

354  V 

58 S 

4 IT

13 TF

38 FN

Thanks for reading this :)

Thanks for reading.