On Jul 18, 2019, at 9:29 AM, Karen Goh <karenworld@xxxxxxxxx> 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 type won't work. Perhaps what you need is a text type with a check constraint to limit it to digits.
