Hi Sreejith, yes that's true --- among others because that's the online you can specify how the data needs to be casted / converted between the types. Best, Stefan ----- On Feb 22, 2018, at 12:20 PM, Sreejith Sharma Sreejith.Sharma@harman.com wrote:

All,

Is it possible to change the datatype of a column in an existing table? With or without data?

I saw the only way to change is to create a temporary column and swap if data is present. Is it true?

Regards,

Sreejith

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |