alter data type

Database
Enthusiast

alter data type

Hi There,

 Can i alter a data type from Decimal(22,5) to varchar(50)?

While i do this it throws me error saying cannot alter specified attribute.. Please help.

1 REPLY
Enthusiast

Re: alter data type

No,

You'll need to create a new table with the new datatype,

Insert from original table , then rename original to old and new to original name.

Once verified, you can drop the old.

RGlass