查看数据库各表大小

1 SELECT A.NAME ,B.ROWS FROM sysobjects A JOIN sysindexes B ON A.id = B.id WHERE A.xtype = 'U' AND B.indid IN(0,1) ORDER BY B.ROWS DESC

 

posted @ 2023-04-21 17:19  蓅烺ゞの貓  阅读(41)  评论(0编辑  收藏  举报