表个数
SELECT count(*) FROM sys.objects WHERE type='U'
视图个数
SELECT count(*) FROM sys.objects WHERE type='V'
存储过程个数
SELECT count(*) FROM sys.objects WHERE type='P'
表个数
SELECT count(*) FROM sys.objects WHERE type='U'
视图个数
SELECT count(*) FROM sys.objects WHERE type='V'
存储过程个数
SELECT count(*) FROM sys.objects WHERE type='P'
转载于:https://www.cnblogs.com/Jeely/p/11199553.html