所有用户表

select OBJECT_NAME(p.object_id),rows from sys.partitions p join sys.tables t on t.object_id = p.object_id

原文地址:https://www.cnblogs.com/zwei1121/p/1887484.html