topic Re: How to change type of numbers after creating fields in attribute table in Data Management Questions https://community.esri.com/t5/data-management-questions/how-to-change-type-of-numbers-after-creating/m-p/733795#M41505 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hi!<BR /><BR />I created a table with several fields. Is it possible to change the type of number, i.e. from short integer to long integer once the field is created?! I cannot find how and where is the option to change it...<BR />thanks in advance!</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>You can't.&nbsp; (Vote for the most popular idea to do this on the Ideas site </SPAN><A href="https://c.na1.visual.force.com/apex/ideaView?id=0873000000087wg&amp;returnUrl=%2Fapex%2FideaList%3Fc%3D09a300000004xET%26category%3D%26sort%3Dpopular">here</A><SPAN>.)&nbsp; You have to create a new field and calculate over the old field values into it (best appraoch if ObjectID values cannot change) or create a new feature class, import the old schema, make the change prior to saving it, and load the data from the old feature class.</SPAN></BODY></HTML> Wed, 08 Feb 2012 13:31:28 GMT RichardFairhurst 2012-02-08T13:31:28Z How to change type of numbers after creating fields in attribute table https://community.esri.com/t5/data-management-questions/how-to-change-type-of-numbers-after-creating/m-p/733794#M41504 <HTML><HEAD></HEAD><BODY><SPAN>Hi!</SPAN><BR /><BR /><SPAN>I created a table with several fields. Is it possible to change the type of number, i.e. from short integer to long integer once the field is created?! I cannot find how and where is the option to change it...</SPAN><BR /><SPAN>thanks in advance!</SPAN></BODY></HTML> Wed, 08 Feb 2012 13:26:44 GMT https://community.esri.com/t5/data-management-questions/how-to-change-type-of-numbers-after-creating/m-p/733794#M41504 audraydelcamp 2012-02-08T13:26:44Z Re: How to change type of numbers after creating fields in attribute table https://community.esri.com/t5/data-management-questions/how-to-change-type-of-numbers-after-creating/m-p/733795#M41505 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hi!<BR /><BR />I created a table with several fields. Is it possible to change the type of number, i.e. from short integer to long integer once the field is created?! I cannot find how and where is the option to change it...<BR />thanks in advance!</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>You can't.&nbsp; (Vote for the most popular idea to do this on the Ideas site </SPAN><A href="https://c.na1.visual.force.com/apex/ideaView?id=0873000000087wg&amp;returnUrl=%2Fapex%2FideaList%3Fc%3D09a300000004xET%26category%3D%26sort%3Dpopular">here</A><SPAN>.)&nbsp; You have to create a new field and calculate over the old field values into it (best appraoch if ObjectID values cannot change) or create a new feature class, import the old schema, make the change prior to saving it, and load the data from the old feature class.</SPAN></BODY></HTML> Wed, 08 Feb 2012 13:31:28 GMT https://community.esri.com/t5/data-management-questions/how-to-change-type-of-numbers-after-creating/m-p/733795#M41505 RichardFairhurst 2012-02-08T13:31:28Z Re: How to change type of numbers after creating fields in attribute table https://community.esri.com/t5/data-management-questions/how-to-change-type-of-numbers-after-creating/m-p/733796#M41506 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">You can't.&nbsp; (Vote for the most popular idea to do this on the Ideas site <A href="https://c.na1.visual.force.com/apex/ideaView?id=0873000000087wg&amp;returnUrl=%2Fapex%2FideaList%3Fc%3D09a300000004xET%26category%3D%26sort%3Dpopular">here</A>.)&nbsp; You have to create a new field and calculate over the old field values into it (best appraoch if ObjectID values cannot change) or create a new feature class, import the old schema, make the change prior to saving it, and load the data from the old feature class.</BLOCKQUOTE><BR /><SPAN>&nbsp; ok, thanks!</SPAN></BODY></HTML> Wed, 08 Feb 2012 13:50:29 GMT https://community.esri.com/t5/data-management-questions/how-to-change-type-of-numbers-after-creating/m-p/733796#M41506 audraydelcamp 2012-02-08T13:50:29Z