DBCC CHECKDB for checking errors in SQL Server database

Question

Can I run: DBCC CHECKDB on a specific table in a SQL Server 2005 database?

I have the following syntax:

 DBCC CHECKDB [ [ ( database_name | database_id | 0 [ , NOINDEX | , { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ] ) ] [ WITH { [ ALL_ERRORMSGS ] [ , EXTENDED_LOGICAL_CHECKS ] [ , NO_INFOMSGS ] [ , TABLOCK ] [ , ESTIMATEONLY ] [ , { PHYSICAL_ONLY | DATA_PURITY } ] } ] ] 

But keep getting the wrong syntax. I just want to run it to see what errors it causes? Can you help me write the syntax? I want to delete all recovery options.

Answer 1

DBCC CHECKDB because it is used to validate databases.

There is a DBCC CHECKTABLE to validate specific tables. Using:

 DBCC CHECKTABLE ('YourTable');