{"id":6849,"date":"2018-12-23T08:59:39","date_gmt":"2018-12-23T08:59:39","guid":{"rendered":"https:\/\/dbtut.com\/?p=6849"},"modified":"2019-01-15T06:45:47","modified_gmt":"2019-01-15T06:45:47","slug":"dbcc-checktable-command-on-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/","title":{"rendered":"DBCC CHECKTABLE Command On SQL Server"},"content":{"rendered":"<p>DBCC CHECKTABLE is used to test the consistency of a table or indexed view. The DBCC CHECKTABLE command performs the same operations as the DBCC CHECKDB command for a table in the database.<\/p>\n<p>You may want to read my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/dbcc-checkdb-command-on-sql-server\/\" target=\"_blank\" rel=\"noopener\">DBCC CHECKDB Command On SQL Server<\/a>&#8220;.<\/p>\n<p><strong>DBCC CHECKTABLE has several different uses. Let&#8217;s examine them all one by one:<\/strong><\/p>\n<p><strong>Consistency Check:<\/strong><\/p>\n<p>The following command detects logical and physical errors in the TestTable table in the Test database.<\/p>\n<pre class=\"lang:default decode:true\">USE Test\nGO\nDBCC CHECKTABLE ('TestTable')<\/pre>\n<p><strong>Consistency Check With NOINDEX:<\/strong><\/p>\n<p>The following query detects errors other than non-clustered indexes in the TestTable table.<\/p>\n<pre class=\"lang:default decode:true\">USE Test\nGO\nDBCC CHECKTABLE (N'TestTable',NOINDEX)<\/pre>\n<p><strong>Correct Errors With\u00a0REPAIR_REBUILD:<\/strong><\/p>\n<p>You can run the DBCC CHECKTABLE command to correct errors in the non-clustereded indexes in the table by using the following command without any loss of data.<\/p>\n<p>The REPAIR_REBUILD operation does not fix any errors that contain filestream data.<\/p>\n<pre class=\"lang:default decode:true\">USE Test\nGO\nALTER DATABASE Test SET SINGLE_USER WITH ROLLBACK IMMEDIATE;\nGO\nDBCC CHECKTABLE (N'TestTable',REPAIR_REBUILD) WITH NO_INFOMSGS, ALL_ERRORMSGS;\nGO\nALTER DATABASE Test SET MULTI_USER;<\/pre>\n<p><strong>Correct Errors With\u00a0REPAIR_ALLOW_DATA_LOSS:<\/strong><\/p>\n<p>You can run the DBCC CHECKTABLE command to correct all errors in the table with the risk of data loss by using the following command.<\/p>\n<pre class=\"lang:default decode:true\">USE Test\nGO\nALTER DATABASE [Test] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;\nGO\nDBCC CHECKTABLE (N'TestTable', REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS;\nGO\nALTER DATABASE [Test] SET MULTI_USER;<\/pre>\n<p>Even if you don&#8217;t write ALL_ERRORMSGS at the end of the script, this is the default value. It means to show all errors received for each object.<\/p>\n<p>NO_INFOMSGS at the end of the script means that it does not display informational messages.<\/p>\n<p><strong>NOTE1:<\/strong> After you make sure that the database is suspect, the first thing we need to do before we start the attempt to recover is to get a backup of the suspect database !!!<\/p>\n<p><strong>NOTE2: <\/strong>After running DBCC CHECKTABLE with REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS, I recommend that you run the DBCC CHECKCONSTRAINTS command. You can find information about this command in my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/02\/dbcc-checkconstraints-command-on-sql-server\/\" target=\"_blank\" rel=\"noopener\">DBCC CHECKCONSTRAINTS Command On SQL Server<\/a>&#8220;.<\/p>\n<p><strong>Logical Consistency Check For Indexed view, XML index, and Spatial Indexes:<\/strong><\/p>\n<p>By default, the DBCC CHECKTABLE command only tests the physical consistency for indexed view, XML index, and spatial indexes.<\/p>\n<p>You can also use the following command to check the logical consistency for indexed view, XML index, and spatial indexes in tables in the databases with compatibility level SQL Server 2008 and later. You may want to read my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/what-is-sql-server-database-compatibility-level-and-how-to-change-database-compatibility-level\/\" target=\"_blank\" rel=\"noopener\">What is SQL Server Database Compatibility Level and How To Change Database Compatibility Level<\/a>&#8220;.<\/p>\n<pre class=\"lang:default decode:true\">USE Test\nGO\nDBCC CHECKTABLE (N'TestTable') WITH EXTENDED_LOGICAL_CHECKS,NO_INFOMSGS, ALL_ERRORMSGS;<\/pre>\n<p>The DBCC CHECKTABLE command uses internal database snapshot. This means that there is no blocking when you run this command.<\/p>\n<p>You may want to read the article named &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/10\/what-is-database-snapshot-on-sql-server\/\" target=\"_blank\" rel=\"noopener\">What is Database Snapshot On SQL Server<\/a>&#8221;<\/p>\n<p><strong>Consistency Check With Lock:<\/strong><\/p>\n<p>If you run using the following command, this command puts the shared table lock on the table instead of using the internal database snapshot. You may want to read my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/sql-server-lock-types\/\" target=\"_blank\" rel=\"noopener\">SQL Server Lock Types<\/a>&#8220;.<\/p>\n<pre class=\"lang:default decode:true\">USE Test\nGO\nDBCC CHECKTABLE (N'TestTable') WITH TABLOCK,NO_INFOMSGS, ALL_ERRORMSGS;<\/pre>\n<p><strong>Calculate Necessary Space For Consistency Check:<\/strong><\/p>\n<p>If you use the following command, no consistency check is performed. Only the amount of space required in tempdb is calculated so that a consistency test can be performed, and it produces an output as follows.<\/p>\n<pre class=\"lang:default decode:true\">USE Test\nGO\nDBCC CHECKTABLE (N'TestTable') WITH ESTIMATEONLY,NO_INFOMSGS, ALL_ERRORMSGS;\nEstimated TEMPDB space (in KB) needed for CHECKTABLE on database Test = 1.<\/pre>\n<p><strong>Only PHYSICAL Consistency Check:<\/strong><\/p>\n<p>When you run it using the command below, only physical consistency check is performed. It is not done logically.<\/p>\n<p>If you ask me, it doesn&#8217;t make sense to run it using this command. Because it doesn&#8217;t control its logical consistency. Of course, they offered us such an option to be used in special cases.<\/p>\n<p>With the PHYSICAL_ONLY command, you cannot perform any REPAIR operation.<\/p>\n<pre class=\"lang:default decode:true\">USE Test\nGO\nDBCC CHECKTABLE (N'TestTable') WITH PHYSICAL_ONLY,NO_INFOMSGS, ALL_ERRORMSGS;<\/pre>\n<p><strong>DATA_PURITY Option:<\/strong><\/p>\n<p>When you run it using the command below, it is checked whether the values of the columns in the tables in the database are compatible with the data type of the column. If your database is SQL Server 2005 or higher, the column values are checked automatically and no DATA_PURITY option is required.<\/p>\n<pre class=\"lang:default decode:true\">USE Test\nGO\nDBCC CHECKTABLE (N'TestTable') WITH DATA_PURITY,NO_INFOMSGS, ALL_ERRORMSGS;<\/pre>\n<p>For faster completion of DBCC CHECKTABLE, you can increase maxdop (max degree of paralellism) from server configurations before running DBCC CHECKTABLE. If your system is an oltp system and consists entirely of small transactions, increasing the maxdop may slow the performance of the running system. Therefore, after increasing the maxdop, you should inspect the system and undo the change in any performance problem. To correctly set the maxdop value, you can use the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/14\/sp_configureserver-level-configurations-in-sql-server\/\" target=\"_blank\" rel=\"noopener\">sp_configure (Server-Level Configurations in SQL Server)<\/a>&#8220;.<\/p>\n<p><strong>DBCC CHECKTABLE For an Index:<\/strong><\/p>\n<p>If you want, you can run the DBCC CHECKTABLE command for just one index. In the script below, we test the clustered index called PK_TestTable in the TestTable table.<\/p>\n<pre class=\"lang:default decode:true\">USE Test\nGO\nDECLARE @IndexId int;\u00a0\u00a0\u00a0\nSET @IndexId = (SELECT index_id\u00a0\u00a0\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM sys.indexes\u00a0\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE object_id = OBJECT_ID('TestTable')\u00a0\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND name = 'PK_TestTable');\u00a0\u00a0\u00a0\n\nDBCC CHECKTABLE ('TestTable',@IndexId);<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6849\" class=\"pvc_stats all  \" data-element-id=\"6849\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>DBCC CHECKTABLE is used to test the consistency of a table or indexed view. The DBCC CHECKTABLE command performs the same operations as the DBCC CHECKDB command for a table in the database. You may want to read my article &#8220;DBCC CHECKDB Command On SQL Server&#8220;. DBCC CHECKTABLE has several different uses. Let&#8217;s examine them &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6849\" class=\"pvc_stats all  \" data-element-id=\"6849\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6849","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":6663,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DBCC CHECKTABLE Command On SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"DBCC CHECKTABLE Command On SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBCC CHECKTABLE Command On SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"DBCC CHECKTABLE Command On SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-23T08:59:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-15T06:45:47+00:00\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"DBCC CHECKTABLE Command On SQL Server\",\"datePublished\":\"2018-12-23T08:59:39+00:00\",\"dateModified\":\"2019-01-15T06:45:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/\"},\"wordCount\":735,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/\",\"name\":\"DBCC CHECKTABLE Command On SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-12-23T08:59:39+00:00\",\"dateModified\":\"2019-01-15T06:45:47+00:00\",\"description\":\"DBCC CHECKTABLE Command On SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBCC CHECKTABLE Command On SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DBCC CHECKTABLE Command On SQL Server - Database Tutorials","description":"DBCC CHECKTABLE Command On SQL Server","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"DBCC CHECKTABLE Command On SQL Server - Database Tutorials","og_description":"DBCC CHECKTABLE Command On SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-23T08:59:39+00:00","article_modified_time":"2019-01-15T06:45:47+00:00","author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"DBCC CHECKTABLE Command On SQL Server","datePublished":"2018-12-23T08:59:39+00:00","dateModified":"2019-01-15T06:45:47+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/"},"wordCount":735,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/","name":"DBCC CHECKTABLE Command On SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-12-23T08:59:39+00:00","dateModified":"2019-01-15T06:45:47+00:00","description":"DBCC CHECKTABLE Command On SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/23\/dbcc-checktable-command-on-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"DBCC CHECKTABLE Command On SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6849","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=6849"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6849\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}