Thank you for your help. Best regards,Baraa
Date: Tue, 5 Nov 2013 08:43:56 +0100 From: Stefan.Manegold@cwi.nl To: users-list@monetdb.org Subject: Re: Modify column datataype
Hi,
given that MonetDB is a column store, an explicit column copy should be sufficient (provided a different column name is acceptable; AFAIK, there is no support to rename a column):
alter table <tab> add column <new_col> <typ>; update <tab> set <new_col> = cast(<old_col> as <typ>); (alter table <tab> drop column <old_col>;)
Stefan
----- Original Message -----
Hello
There is no support (yet) for changing the underlying type of an individual column. It requires an explicit table copy.
regards, Martin
On 11/5/13 1:06 AM, baraa Mohamad wrote:
Hello,
I would like to know if it is possible to change a column type. I have a table with millions of records and I wand to change the type of the column (id) but I couldn't find how to do that.
Thanks in advance for your help,
Regards, Baraa
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
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) |
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list