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
转载于:https://www.cnblogs.com/taobox/articles/2793950.html