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
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
转载于:https://www.cnblogs.com/hzprogram/archive/2013/01/21/2869622.html