SQL SERVER统计数据表，视图，存储过程的个数

SELECT COUNT(*) 存储过程个数
FROM SYS.SYSOBJECTS
WHERE (XTYPE = 'P')
GO

SELECT COUNT(*) 视图个数
FROM SYS.SYSOBJECTS
WHERE (XTYPE = 'V')
GO

SELECT COUNT(*) 表个数
FROM SYS.SYSOBJECTS
WHERE (XTYPE = 'U')
GO