Changing field type or column datatypeThe purpose of this article is to provide information about suggestions when changing the field type of the column Changing the data type of column/field Generally, It is highly recommended to avoid changing the type of a column. Experience has shown that a better approach is to create a new column with the new data type and copy the data from the old column to the new column Steps to follow to change the data type 1. Create a new column with the new datatype 2. Copy the data from the old column to the new column 3. Rename the original column label This is all so as not to break customer customizations and avoid loss of data. Additional Resources Export all or only specific columns using XMLBest practices for field Datatype changeCan we change data types once create a table?Example i created X table its have some field before its string field then i would like change integer its possible?Copy field value from one table to anothercopy contents of one field in to another