本文介绍了DBCC CHECKDB说明......的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
任何人都可以详细解释一下DBCC CHECKDB。
我也到了微软网站，但我无法理解它。
所以你能解释一下吗？我以一种简单的方式..
Can any one explain about DBCC CHECKDB in detail.
I got to the Microsoft site also but I was not able to understand it there.
So can you explain me in a simple way..
推荐答案
-- Check the current database.
DBCC CHECKDB;
GO
-- Check the AdventureWorks2012 database without nonclustered indexes.
DBCC CHECKDB (AdventureWorks2012, NOINDEX);
GO
现在阅读。 []
[]
[]
我希望你现在能理解。
read now. DBCC CHECKDB[^]
DBCC CHECKALLOC[^]
DBCC CHECKTABLE[^]
I hope you can understand now.
This command is used to reset the identity fields on the table.whenever you delete rows,the identity column will not reset by default.
To reset the identity column,Run the following command:
DBCC CHECKIDENT ('[TestTable]', RESEED, 0)
这篇关于DBCC CHECKDB说明......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！