Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Wed, Oct 31 2007 1:25 PM	Permanent Link
"Jianfei Xu"	Hi, I am migrating DBISAM to EDB. I need to be able to alter column to different type, name, size and keep the data. Does this ALTER COLUMN AS support this. Jianfei
Thu, Nov 1 2007 5:04 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Jianfei, << I am migrating DBISAM to EDB. I need to be able to alter column to different type, name, size and keep the data. Does this ALTER COLUMN AS support this. >> Everything except for the name - you cannot rename a column yet without dropping and re-adding the column with a different name, and that will lose the data. We will be adding a RENAME column option shortly that will allow for renaming. -- Tim Young Elevate Software www.elevatesoft.com
Thu, Nov 1 2007 6:59 PM	Permanent Link
"Jianfei Xu"	Great, I can just wait. Thanks Jianfei > Jianfei, > > << I am migrating DBISAM to EDB. I need to be able to alter column to > different type, name, size and keep the data. Does this ALTER COLUMN AS > support this. >> > > Everything except for the name - you cannot rename a column yet without > dropping and re-adding the column with a different name, and that will > lose the data. We will be adding a RENAME column option shortly that will > allow for renaming. > > -- > Tim Young > Elevate Software > www.elevatesoft.com >