Alter Column

[albertkhor]

i using sqlce. Why below alter column cannot work? Can some one tell me what is the error?

ALTER TABLE "Product" ALTER COLUMN "Name" nvarchar(255);

 

[strider]

have you tried using single quotes?

what does the error message say?

 

[albertkhor]

strider, thanks for your reply.
i read on one article said that is not possible to change the data type. Alter column for sqlce only allow to change the dafault and identity only.

anywhere i already save this problem by create a temp field and copy all the data to the temp field, after that delete the field that i want to change the data type then create again the field and copy all data from temp field. finally delete the temp field. (poor english )