Requirement : Currently there is a table with a column ref_no having datatype as integer. And the table holds one million records.
Now the reference number is going to be a character datatype (alpla numeric). I need to change the column from integer to character datatype.
Is it possible with out dropping the table and recreating with new datatype.
like using alter command.
I dont think you can change the column attributes of table using alter command (exception char to varchar etc). What I may suggest is ADD a new column in the table using ALTER table and then run a mass update on the table to equate the NEW = CHAR(OLD).
And then use this NEW field in your code for all purposes