Hi Joy,
I have a table with 5 columns and each column has its own data type set different than Auto().
When I add later a new column to the table then visual studio changes the data type automatically for one or two existing columns.
Ex:
- Table1 is created with Column1 data type set to "text" automatically, I changed manually Column1 data type to "whole number".
- Later I add Column2 to the same table and then visual studio automatically changes the data type for Column1 back to "text".