统计数据库中表，视图，存储过程个数

SELECT count(1) 存储过程个数
FROM sys.sysobjects
WHERE type = 'P'
GO

SELECT count(1) 视图个数
FROM sys.sysobjects
WHERE type = 'V'
GO

SELECT count(1) 表个数
FROM sys.sysobjects
WHERE type = 'U'
GO