SQL数据库管理

1获得每个用户表的记录数和容量EXEC sp_MSforeachtable @whereand="and xtype='u' and status>=0", @command1="print '?'",  @command2="sp_spaceused '?'",    @command3="SELECT count(*) FROM ?"
原文地址:https://www.cnblogs.com/pengzhihua/p/2212372.html