I want to alter my table column from VARCHAR(4000) Latin to Unicode .
Please help with the alter table syntax if feasible or any differnt approch for the same.
Do we have alter option for this change or rename & then recreate is the only way.
Thanks in advance.
If you don't want to drop and recreate the table you could add a new Unicode column,
Update it with the contents of Latin column, then drop the Latin column and rename the Unicode to original name.