CheckTablesDataOnly Method

Database.CheckTablesDataOnly Method

 

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

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubmethodCheckTablesDataOnly()

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

System_CAPS_pubmethodCheckTablesDataOnly(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.

System_CAPS_pubmethodCheckTablesDataOnly(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.

System_CAPS_pubmethodCheckTablesDataOnly(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.

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

Return to top
Show:
© 2016 Microsoft