This topic has not yet been rated - Rate this topic

Database.CheckTablesDataOnly Method

SQL Server 2008

Tests integrity of data in pages that store data for all tables and indexes defined on the tables of the referenced database.

	Name	Description
	CheckTablesDataOnly()	Tests integrity of data in pages that store data for all tables and indexes defined on the tables of the referenced database.
	CheckTablesDataOnly(RepairOptions)	Tests integrity of data in pages that store data for all tables and indexes defined on the tables of the referenced database, with the specified repair options.
	CheckTablesDataOnly(RepairStructure)	Tests integrity of data in pages that store data for all tables and indexes defined on the tables of the referenced database with the specified repair structure.
	CheckTablesDataOnly(RepairOptions, RepairStructure)	Tests integrity of data in pages that store data for all tables and indexes defined on the tables of the referenced database with the specified repair options and repair structure.

This method is equivalent to the DBCC CHECKTABLE Transact-SQL command.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions