{"id":200980,"date":"2025-07-05T00:00:56","date_gmt":"2025-07-05T00:00:56","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/"},"modified":"2025-07-05T00:00:56","modified_gmt":"2025-07-05T00:00:56","slug":"how-to-change-the-identity-value-in-sql-server","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/","title":{"rendered":"How to change the identity value in SQL Server?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#How_to_change_the_identity_value_in_SQL_Server\" title=\"How to change the identity value in SQL Server?\">How to change the identity value in SQL Server?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#FAQs\" title=\"FAQs:\">FAQs:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#Can_I_change_the_identity_value_of_a_column_that_is_part_of_a_primary_key\" title=\"Can I change the identity value of a column that is part of a primary key?\">Can I change the identity value of a column that is part of a primary key?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#What_happens_if_I_set_the_new_identity_value_to_an_existing_value\" title=\"What happens if I set the new identity value to an existing value?\">What happens if I set the new identity value to an existing value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#Can_I_change_the_identity_value_of_a_column_in_a_table_with_data\" title=\"Can I change the identity value of a column in a table with data?\">Can I change the identity value of a column in a table with data?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#Do_I_need_special_permissions_to_change_the_identity_value_in_SQL_Server\" title=\"Do I need special permissions to change the identity value in SQL Server?\">Do I need special permissions to change the identity value in SQL Server?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#What_happens_if_I_set_the_new_identity_value_to_a_negative_number\" title=\"What happens if I set the new identity value to a negative number?\">What happens if I set the new identity value to a negative number?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#Can_I_change_the_identity_value_of_a_column_in_a_table_with_foreign_key_constraints\" title=\"Can I change the identity value of a column in a table with foreign key constraints?\">Can I change the identity value of a column in a table with foreign key constraints?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#Is_it_recommended_to_frequently_change_the_identity_value_in_SQL_Server\" title=\"Is it recommended to frequently change the identity value in SQL Server?\">Is it recommended to frequently change the identity value in SQL Server?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#Can_I_change_the_identity_value_of_a_column_using_the_GUI_in_SQL_Server_Management_Studio\" title=\"Can I change the identity value of a column using the GUI in SQL Server Management Studio?\">Can I change the identity value of a column using the GUI in SQL Server Management Studio?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#What_if_I_accidentally_set_the_wrong_new_identity_value\" title=\"What if I accidentally set the wrong new identity value?\">What if I accidentally set the wrong new identity value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#Can_I_change_the_identity_value_of_a_column_from_incrementing_by_1_to_a_different_number\" title=\"Can I change the identity value of a column from incrementing by 1 to a different number?\">Can I change the identity value of a column from incrementing by 1 to a different number?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#What_is_the_impact_of_changing_the_identity_value_on_existing_queries_and_applications\" title=\"What is the impact of changing the identity value on existing queries and applications?\">What is the impact of changing the identity value on existing queries and applications?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"How_to_change_the_identity_value_in_SQL_Server\"><\/span>How to change the identity value in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you create a table in SQL Server and specify a column as an identity column, the identity property automatically generates unique values for new rows. But what if you need to change the identity value to a different number? Here&#8217;s how you can do it:<\/p>\n<p>1. **Identify the column:** The first step is to identify the column that has the identity property in your table.<\/p>\n<p>2. **Turn off the identity property:** Use the following command:<br \/>\n   &#8220;`sql<br \/>\n   SET IDENTITY_INSERT TableName OFF;<br \/>\n   &#8220;`<br \/>\n   Replace &#8220;TableName&#8221; with the name of your table.<\/p>\n<p>3. **Update the identity value:** You can update the identity value using the following command:<br \/>\n   &#8220;`sql<br \/>\n   DBCC CHECKIDENT (&#8216;TableName&#8217;, RESEED, NewValue);<br \/>\n   &#8220;`<br \/>\n   Replace &#8220;TableName&#8221; with the name of your table and &#8220;NewValue&#8221; with the new identity value you want to set.<\/p>\n<p>4. **Turn on the identity property:** Lastly, turn the identity property back on using:<br \/>\n   &#8220;`sql<br \/>\n   SET IDENTITY_INSERT TableName ON;<br \/>\n   &#8220;`<\/p>\n<p>By following these steps, you can change the identity value in SQL Server.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_change_the_identity_value_of_a_column_that_is_part_of_a_primary_key\"><\/span>Can I change the identity value of a column that is part of a primary key?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, you cannot change the identity value of a column that is part of a primary key without first dropping the primary key constraint.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_happens_if_I_set_the_new_identity_value_to_an_existing_value\"><\/span>What happens if I set the new identity value to an existing value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf you set the new identity value to an existing value, SQL Server will throw an error. The identity column must always contain unique values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_change_the_identity_value_of_a_column_in_a_table_with_data\"><\/span>Can I change the identity value of a column in a table with data?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can change the identity value of a column in a table with data. Just make sure to update the existing rows accordingly.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Do_I_need_special_permissions_to_change_the_identity_value_in_SQL_Server\"><\/span>Do I need special permissions to change the identity value in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you need ALTER permission on the table to change the identity value in SQL Server.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_happens_if_I_set_the_new_identity_value_to_a_negative_number\"><\/span>What happens if I set the new identity value to a negative number?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nSetting the new identity value to a negative number is not recommended as it can lead to unexpected behavior in your application.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_change_the_identity_value_of_a_column_in_a_table_with_foreign_key_constraints\"><\/span>Can I change the identity value of a column in a table with foreign key constraints?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can change the identity value of a column in a table with foreign key constraints. Just make sure to update the foreign key values accordingly.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Is_it_recommended_to_frequently_change_the_identity_value_in_SQL_Server\"><\/span>Is it recommended to frequently change the identity value in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, it is not recommended to frequently change the identity value as it can lead to data inconsistencies in your database.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_change_the_identity_value_of_a_column_using_the_GUI_in_SQL_Server_Management_Studio\"><\/span>Can I change the identity value of a column using the GUI in SQL Server Management Studio?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can change the identity value of a column using the GUI in SQL Server Management Studio by modifying the table design.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_if_I_accidentally_set_the_wrong_new_identity_value\"><\/span>What if I accidentally set the wrong new identity value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf you accidentally set the wrong new identity value, you can always revert back to the original value by following the same steps.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_change_the_identity_value_of_a_column_from_incrementing_by_1_to_a_different_number\"><\/span>Can I change the identity value of a column from incrementing by 1 to a different number?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can change the identity increment value by altering the table and specifying a new increment value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_is_the_impact_of_changing_the_identity_value_on_existing_queries_and_applications\"><\/span>What is the impact of changing the identity value on existing queries and applications?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nChanging the identity value will impact existing queries and applications that rely on the specific identity values, so make sure to update them accordingly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to change the identity value in SQL Server? When you create a table in SQL Server and specify a column as an identity column, the identity property automatically generates unique values for new rows. But what if you need to change the identity value to a different number? Here&#8217;s how you can do it: &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to change the identity value in SQL Server?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#more-200980\">Read more<span class=\"screen-reader-text\">How to change the identity value in SQL Server?<\/span><\/a><\/p>\n","protected":false},"author":51,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-200980","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to change the identity value in SQL Server?<\/title>\n<meta name=\"description\" content=\"How to change the identity value in SQL Server? When you create a table in SQL Server and specify a column as an identity column, the identity property\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to change the identity value in SQL Server?\" \/>\n<meta property=\"og:description\" content=\"How to change the identity value in SQL Server? When you create a table in SQL Server and specify a column as an identity column, the identity property\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-05T00:00:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Adam Forbes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Adam Forbes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/\"},\"author\":{\"name\":\"Adam Forbes\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\"},\"headline\":\"How to change the identity value in SQL Server?\",\"datePublished\":\"2025-07-05T00:00:56+00:00\",\"dateModified\":\"2025-07-05T00:00:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/\"},\"wordCount\":579,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/\",\"name\":\"How to change the identity value in SQL Server?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2025-07-05T00:00:56+00:00\",\"dateModified\":\"2025-07-05T00:00:56+00:00\",\"description\":\"How to change the identity value in SQL Server? When you create a table in SQL Server and specify a column as an identity column, the identity property\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to change the identity value in SQL Server?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\",\"name\":\"Adam Forbes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Adam Forbes\"},\"description\":\"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to change the identity value in SQL Server?","description":"How to change the identity value in SQL Server? When you create a table in SQL Server and specify a column as an identity column, the identity property","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:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How to change the identity value in SQL Server?","og_description":"How to change the identity value in SQL Server? When you create a table in SQL Server and specify a column as an identity column, the identity property","og_url":"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2025-07-05T00:00:56+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Adam Forbes","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Adam Forbes","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/"},"author":{"name":"Adam Forbes","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060"},"headline":"How to change the identity value in SQL Server?","datePublished":"2025-07-05T00:00:56+00:00","dateModified":"2025-07-05T00:00:56+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/"},"wordCount":579,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/","url":"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/","name":"How to change the identity value in SQL Server?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2025-07-05T00:00:56+00:00","dateModified":"2025-07-05T00:00:56+00:00","description":"How to change the identity value in SQL Server? When you create a table in SQL Server and specify a column as an identity column, the identity property","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-change-the-identity-value-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to change the identity value in SQL Server?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060","name":"Adam Forbes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Adam Forbes"},"description":"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/200980","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/51"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=200980"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/200980\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=200980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=200980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=200980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}