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
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
转载于:https://www.cnblogs.com/zhang9418hn/p/3222957.html