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