DBCC CHECKDB
Checks integrity of all tables in the database.
DBCC CHECKTABLE
Checks integrity of the table.
DBCC CHECKTABLE ("HumanResources.Employee")
Options include:
DBCC CHECKTABLE ("HumanResources.Employee") WITH PHYSICAL_ONLY - low overhread check recommended for large tables
DBCC CHECKTABLE ("HumanResources.Employee") WITH TABLOCK - table becomes read-only while command is being run