select  b.name as tablename ,  

        a.rowcnt as datacount  
from    sysindexes a ,  
        sysobjects b  
where   a.id = b.id  
        and a.indid < 2  
        and objectproperty(b.id, 'IsMSShipped') = 0 

文章如转载，请注明转载自：http://www.5iadmin.com/post/1084.html