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,则该值包含重复的计数。
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,则该值包含重复的计数。
转载于:https://www.cnblogs.com/ea7son/p/3392820.html