SqlServler

1.查询当前数据库下 每个表的数据行数:

select a.name,MaxRows =Max(b.rows)from sys.tables a
inner join sys.partitions b
on a.object_id=b.object_id
group by a.name

posted @ 2019-11-13 16:10  auldlangsynezh  阅读(120)  评论(0编辑  收藏  举报