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.