On Jul 18, 2019, at 9:29 AM, Karen Goh <karenworld@yahoo.com> wrote:
>
> I need help to change an existing column in my table from text to 'digit' type.
>
> However, I can't find any numeric or integer property type.
>
> The digit type should contains numbers only but it is not for calculation. It is a zipcode that has 6 digit numbers.
There is no digit type. I assume your 6-digit numbers can have leading 0s which need to be preserved, so an integer
typewon't work. Perhaps what you need is a text type with a check constraint to limit it to digits.