{"id":6031,"date":"2018-11-28T11:38:58","date_gmt":"2018-11-28T11:38:58","guid":{"rendered":"https:\/\/dbtut.com\/?p=6031"},"modified":"2018-11-28T11:43:47","modified_gmt":"2018-11-28T11:43:47","slug":"how-to-set-identity-property-to-the-current-column-in-the-table","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/","title":{"rendered":"How To Set Identity Property to the Current Column in the Table"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Before reading this article, I suggest you read my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/identitiy-insert-on-sql-server\/\" target=\"_blank\" rel=\"noopener\">Identitiy Insert On SQL Server<\/a>&#8221; to see what the identitiy property is in the table.<\/p>\n<p>This article describes how to set an identitiy property to an existing column in a table.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>You can do this with two method:<\/strong><\/p>\n<p>1. Create a new table with the Identitity property and transfer the existing records to this new table<\/p>\n<p>2. Add a new column with identity to the table and delete the old column<\/p>\n<p>&nbsp;<\/p>\n<p>First of all, with the help of the following script, let&#8217;s create a table that contains the ID and Name columns and the identity property is not set.<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLE [dbo].[IdentitiyExampleTable](\r\n[ID] [int] NULL,\r\n[Name] [varchar](250) NULL\r\n) ON [PRIMARY]\r\nGO\r\nINSERT INTO [dbo].[IdentitiyExampleTable]([ID],[Name])VALUES (1,'Nurullah CAKIR')\r\nINSERT INTO [dbo].[IdentitiyExampleTable]([ID],[Name])VALUES (3,'Faruk ERDEM')\r\nINSERT INTO [dbo].[IdentitiyExampleTable]([ID],[Name])VALUES (2,'Hakan GURBASLAR')<\/pre>\n<p>&nbsp;<\/p>\n<p>Let&#8217;s perform these operations on our example table with the two method mentioned above.<\/p>\n<p>&nbsp;<\/p>\n<h3>1. Create a new table with the Identitity property and transfer the existing records to this new table:<\/h3>\n<p>Right click on the table and click the design as below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/435-1.png\" width=\"486\" height=\"140\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>By clicking on the column we want to set Identity property, we open the tree structure of Identity Specification from below and double click on where you see No in Identity section. The values will change as you see on the screen below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/585-2.png\" width=\"500\" height=\"160\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Then we click Table Designer-&gt;Generate Change Sript to get the script of the changes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/961-1.png\" width=\"458\" height=\"301\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>A script is generated as follows.<\/p>\n<pre class=\"lang:default decode:true\">\/* To prevent any potential data loss issues, \r\nyou should review this script in detail before running it outside the context of the database designer.*\/\r\nBEGIN TRANSACTION\r\nSET QUOTED_IDENTIFIER ON\r\nSET ARITHABORT ON\r\nSET NUMERIC_ROUNDABORT OFF\r\nSET CONCAT_NULL_YIELDS_NULL ON\r\nSET ANSI_NULLS ON\r\nSET ANSI_PADDING ON\r\nSET ANSI_WARNINGS ON\r\nCOMMIT\r\nBEGIN TRANSACTION\r\nGO\r\nCREATE TABLE dbo.Tmp_IdentitiyExampleTable\r\n(\r\nID int NOT NULL IDENTITY (1, 1),\r\nName varchar(250) NULL\r\n)\u00a0 ON [PRIMARY]\r\nGO\r\n\r\nALTER TABLE dbo.Tmp_IdentitiyExampleTable SET (LOCK_ESCALATION = TABLE)\r\nGO\r\nSET IDENTITY_INSERT dbo.Tmp_IdentitiyExampleTable ON\r\nGO\r\nIF EXISTS(SELECT * FROM dbo.IdentitiyExampleTable)\r\n\u00a0EXEC('INSERT INTO dbo.Tmp_IdentitiyExampleTable (ID, Name)\r\nSELECT ID, Name FROM dbo.IdentitiyExampleTable WITH (HOLDLOCK TABLOCKX)')\r\nGO\r\nSET IDENTITY_INSERT dbo.Tmp_IdentitiyExampleTable OFF\r\nGO\r\nDROP TABLE dbo.IdentitiyExampleTable\r\nGO\r\nEXECUTE sp_rename N'dbo.Tmp_IdentitiyExampleTable', N'IdentitiyExampleTable', 'OBJECT'\r\nGO\r\nCOMMIT<\/pre>\n<p>&nbsp;<\/p>\n<p>As you can see in this script, it creates a new table, transfers the records in the current table to the new table, and deletes the old table and changes the name of the newly created table.<\/p>\n<p>If your table is large, this process will take a long time and your system will not work as long as this process is in progress, but this is the only way you can work if your existing ID values need to be protected.<\/p>\n<p>Also, if your table is too large, make sure that the disk containing the log file is sufficient for you.<\/p>\n<p>&nbsp;<\/p>\n<h3>2) Add a new column with identity to the table and delete the old column:<\/h3>\n<p>With the help of the following script, you can delete the existing column that you want to make the identity and add a new column with the identity property to the table. But in this way the values of your existing ID column will be deleted and re-created from scratch.<\/p>\n<p>If you want the current values in the ID column not to be deleted, I recommend that you use method 1. As an additional information, method 2 will be completed much faster than method 1.<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE dbo.IdentitiyExampleTable DROP COLUMN ID\r\nALTER TABLE [dbo].[IdentitiyExampleTable] ADD ID INT IDENTITY (1, 1) NOT NULL;<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6031\" class=\"pvc_stats all  \" data-element-id=\"6031\" 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; Before reading this article, I suggest you read my article &#8220;Identitiy Insert On SQL Server&#8221; to see what the identitiy property is in the table. This article describes how to set an identitiy property to an existing column in a table. &nbsp; You can do this with two method: 1. Create a new table &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6031\" class=\"pvc_stats all  \" data-element-id=\"6031\" 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-6031","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":274,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Set Identity Property to the Current Column in the Table - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Set Identity Property to the Current Column in the Table\" \/>\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\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Set Identity Property to the Current Column in the Table - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Set Identity Property to the Current Column in the Table\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-28T11:38:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-28T11:43:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/435-1.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=\"3 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\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Set Identity Property to the Current Column in the Table\",\"datePublished\":\"2018-11-28T11:38:58+00:00\",\"dateModified\":\"2018-11-28T11:43:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/\"},\"wordCount\":436,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/435-1.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/\",\"name\":\"How To Set Identity Property to the Current Column in the Table - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/435-1.png\",\"datePublished\":\"2018-11-28T11:38:58+00:00\",\"dateModified\":\"2018-11-28T11:43:47+00:00\",\"description\":\"How To Set Identity Property to the Current Column in the Table\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/435-1.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/435-1.png\",\"width\":711,\"height\":205},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Set Identity Property to the Current Column in the Table\"}]},{\"@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":"How To Set Identity Property to the Current Column in the Table - Database Tutorials","description":"How To Set Identity Property to the Current Column in the Table","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\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/","og_locale":"en_US","og_type":"article","og_title":"How To Set Identity Property to the Current Column in the Table - Database Tutorials","og_description":"How To Set Identity Property to the Current Column in the Table","og_url":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/","og_site_name":"Database Tutorials","article_published_time":"2018-11-28T11:38:58+00:00","article_modified_time":"2018-11-28T11:43:47+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/435-1.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Set Identity Property to the Current Column in the Table","datePublished":"2018-11-28T11:38:58+00:00","dateModified":"2018-11-28T11:43:47+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/"},"wordCount":436,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/435-1.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/","url":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/","name":"How To Set Identity Property to the Current Column in the Table - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/435-1.png","datePublished":"2018-11-28T11:38:58+00:00","dateModified":"2018-11-28T11:43:47+00:00","description":"How To Set Identity Property to the Current Column in the Table","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/435-1.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/435-1.png","width":711,"height":205},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-set-identity-property-to-the-current-column-in-the-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Set Identity Property to the Current Column in the Table"}]},{"@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\/6031","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=6031"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6031\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}