{"id":9503,"date":"2019-02-15T11:50:00","date_gmt":"2019-02-15T11:50:00","guid":{"rendered":"https:\/\/dbtut.com\/?p=9503"},"modified":"2019-02-15T11:50:00","modified_gmt":"2019-02-15T11:50:00","slug":"dbcc-checkident-in-sql-servertsql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/","title":{"rendered":"DBCC CHECKIDENT in SQL Server(TSQL)"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>The following operations can be performed with the DBCC CHECKIDENT command.<\/p>\n<ul>\n<li>The current identitiy value of an identity column can be found.<\/li>\n<li>The maximum identitiy value of an identitiy column can be found.<\/li>\n<li>The current identitiy value of an identity column can be set as any number.<\/li>\n<li>The current identitiy value of an identitiy column can be set as the maximum identitiy value.<\/li>\n<\/ul>\n<p>First, we create a table with the help of the following script and add a few records into this table.<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLE [dbo].[MyTable]\r\n([ID] INT IDENTITY(3,2),\r\n\u00a0[Name] VARCHAR(100) NULL\r\n)\r\nINSERT [dbo].[MyTable]\r\nVALUES ('Hakan GURBASLAR'),('Nurullah CAKIR'),('Faruk ERDEM')\r\nGO\r\nSELECT * FROM [dbo].[MyTable]<\/pre>\n<p id=\"huiNKxF\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9505  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5b9eaecd.png\" alt=\"\" width=\"754\" height=\"382\" \/><\/p>\n<p><strong>Find current and maximum identitiy value of an identitiy column:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">DBCC CHECKIDENT ( '[dbo].[MyTable]', NORESEED )<\/pre>\n<p id=\"CnComlD\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9507  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5e2a36bd.png\" alt=\"\" width=\"730\" height=\"156\" \/><\/p>\n<p><strong>Set an identity column&#8217;s current identity value to any number:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">DBCC CHECKIDENT ( '[dbo].[MyTable]', RESEED,10 )\r\n\r\nINSERT [dbo].[MyTable] VALUES ('This is the first record after the current identity changed.')\r\n\r\nSELECT * FROM [dbo].[MyTable]<\/pre>\n<p id=\"ARlzOdi\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9509  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a60f25506.png\" alt=\"\" width=\"802\" height=\"262\" \/><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><strong>Set the Current Identitiy value as a lower number:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">DBCC CHECKIDENT ( '[dbo].[MyTable]', RESEED,8 )\r\n\r\nINSERT [dbo].[MyTable] VALUES ('This is the first record after the current identity changed second time.')\r\n\r\nSELECT * FROM [dbo].[MyTable]<\/pre>\n<p id=\"biLqnWT\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9511  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a65dc6a96.png\" alt=\"\" width=\"777\" height=\"235\" \/><\/p>\n<p><strong>Let&#8217;s check the current and maximum identitiy again:<\/strong><\/p>\n<p>As you can see, Current identity value is 10 while maximum identity value is 12.<\/p>\n<pre class=\"lang:default decode:true \">DBCC CHECKIDENT ( '[dbo].[MyTable]', NORESEED )<\/pre>\n<p id=\"yFjfOgj\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9513  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a68c287b6.png\" alt=\"\" width=\"752\" height=\"181\" \/><\/p>\n<p><strong>To set the current identity value of an identity column as the maximum identitiy value:<\/strong><\/p>\n<p>If the current identity value is smaller than the maximum identitiy value, we can set the current identitiy value as the maximum identity value as follows.<\/p>\n<pre class=\"lang:default decode:true \">DBCC CHECKIDENT ( '[dbo].[MyTable]', RESEED )<\/pre>\n<p id=\"ZJDWOpO\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9515  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a6c6e3066.png\" alt=\"\" width=\"779\" height=\"167\" \/><\/p>\n<p><strong>Check the current and maximum identitiy value again:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">DBCC CHECKIDENT ( '[dbo].[MyTable]', NORESEED )<\/pre>\n<p id=\"PFfZLeO\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9517  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a6f2310c1.png\" alt=\"\" width=\"765\" height=\"194\" \/><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9503\" class=\"pvc_stats all  \" data-element-id=\"9503\" 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>&nbsp; The following operations can be performed with the DBCC CHECKIDENT command. The current identitiy value of an identity column can be found. The maximum identitiy value of an identitiy column can be found. The current identitiy value of an identity column can be set as any number. The current identitiy value of an identitiy &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9503\" class=\"pvc_stats all  \" data-element-id=\"9503\" 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,1596],"tags":[2031,2029,2030,2032,2033],"class_list":["post-9503","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-change-identitiy-value","tag-check-the-current-identitiy-value","tag-check-the-maximum-identitiy-value","tag-find-current-identitiy-value","tag-find-maximum-identitiy-value"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DBCC CHECKIDENT in SQL Server(TSQL) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"DBCC CHECKIDENT in SQL Server(TSQL)\" \/>\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\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBCC CHECKIDENT in SQL Server(TSQL) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"DBCC CHECKIDENT in SQL Server(TSQL)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-15T11:50:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5b9eaecd.png\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"DBCC CHECKIDENT in SQL Server(TSQL)\",\"datePublished\":\"2019-02-15T11:50:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/\"},\"wordCount\":192,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5b9eaecd.png\",\"keywords\":[\"change identitiy value\",\"Check the current identitiy value\",\"Check the maximum identitiy value\",\"find current identitiy value\",\"find maximum identitiy value\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/\",\"name\":\"DBCC CHECKIDENT in SQL Server(TSQL) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5b9eaecd.png\",\"datePublished\":\"2019-02-15T11:50:00+00:00\",\"description\":\"DBCC CHECKIDENT in SQL Server(TSQL)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5b9eaecd.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5b9eaecd.png\",\"width\":788,\"height\":399},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBCC CHECKIDENT in SQL Server(TSQL)\"}]},{\"@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 CHECKIDENT in SQL Server(TSQL) - Database Tutorials","description":"DBCC CHECKIDENT in SQL Server(TSQL)","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\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/","og_locale":"en_US","og_type":"article","og_title":"DBCC CHECKIDENT in SQL Server(TSQL) - Database Tutorials","og_description":"DBCC CHECKIDENT in SQL Server(TSQL)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-15T11:50:00+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5b9eaecd.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"DBCC CHECKIDENT in SQL Server(TSQL)","datePublished":"2019-02-15T11:50:00+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/"},"wordCount":192,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5b9eaecd.png","keywords":["change identitiy value","Check the current identitiy value","Check the maximum identitiy value","find current identitiy value","find maximum identitiy value"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/","name":"DBCC CHECKIDENT in SQL Server(TSQL) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5b9eaecd.png","datePublished":"2019-02-15T11:50:00+00:00","description":"DBCC CHECKIDENT in SQL Server(TSQL)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5b9eaecd.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c66a5b9eaecd.png","width":788,"height":399},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/15\/dbcc-checkident-in-sql-servertsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"DBCC CHECKIDENT in SQL Server(TSQL)"}]},{"@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\/9503","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=9503"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9503\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}