sys.indexes与sysindexes区别


Warning: Undefined array key "HTTP_REFERER" in /www/wwwroot/prod/www.enjoyasp.net/wp-content/plugins/google-highlight/google-hilite.php on line 58

保留sysindexes是为了向后兼容sql server2000之前的版本,以后可能就不再使用,而是以sys.为主
故查询一个表有多少行时可用:

SELECT *
FROM sys.partitions where object_id = object_id(‘bdorder’) and index_id = 1