>>I guess having 0 decimals is OK. News to me. I've always used int (or double if int wasn't big enough).
>
>I would like to change this column to Integer but I have to keep it in sync with VFP database. And in the VFP database it is numeric(6,0).
I think you may want to change it to int sooner than later. Say, we have in our tables primary keys numeric(17) while we could have used bigint and saved space. This is only because our tables were also migrated from VFP.
In my opinion, it is better to get the structure right from the beginning than to attempt to alter in the middle of the process.
If it's not broken, fix it until it is.
My Blog