SQL统计表 视图 存储过程的个数
SELECT count(*) --存储过程个数 FROM sys.sysobjects WHERE (type = 'P') GO SELECT count(*) --视图个数 FROM sys.sysobjects WHERE (type = 'V') GO SELECT count(*) --表个数 FROM sys.sysobjects WHERE (type = 'U') GO
量的积累到质的飞越
SELECT count(*) --存储过程个数 FROM sys.sysobjects WHERE (type = 'P') GO SELECT count(*) --视图个数 FROM sys.sysobjects WHERE (type = 'V') GO SELECT count(*) --表个数 FROM sys.sysobjects WHERE (type = 'U') GO