use [dbname] go select rows from sysindexes where id = object_id('tablename') and indid between 0 and 1
indid 索引ID 0=堆 1=聚集索引 >1 =非聚集索引
rows 基于 indid = 0 和 indid = 1 的数据级行计数,如果 indid >1,则该值包含重复的计数。