我的運行結果
DBCC results for 'authors'.
There are 23 rows in 1 pages for object 'authors'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
能解釋一下嗎?
B. 检查表,但不检查非聚集索引
下例对 authors 表的数据页完整性进行检查,但不检查非聚集索引。
DBCC CHECKTABLE ('authors') WITH PHYSICAL_ONLY
GO
C. 检查特定索引
下例对通过访问 sysindexes 获得的特定索引进行检查。
USE pubs
DECLARE @indid int
SELECT @indid = indid
FROM sysindexes
WHERE id = OBJECT_ID('authors') AND name = 'aunmind'
DBCC CHECKTABLE ('authors', @indid)
GO