表个数
SELECT count(*) FROM sys.objects WHERE type='U'
视图个数
SELECT count(*) FROM sys.objects WHERE type='V'
存储过程个数
SELECT count(*) FROM sys.objects WHERE type='P'
本文共 212 字,大约阅读时间需要 1 分钟。
表个数
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/Williamls/p/9435825.html