Changing field type | change datatype of column


1. Overview

The purpose of this article is to provide information about suggestions when changing the field type of the columnĀ 

2. 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 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.

3. Additional Resources

Export all or only specific columns using XML

Best practices for field Datatype change

Can 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 another

copy contents of one field in to another