列出当前数据库中所有表的大小的SQL语句

select object_name(id),rowcnt from sysindexes where indid<2 and objectproperty(id,'isusertable')=1 order by 2 desc