|
View previous topic :: View next topic
|
| Author |
Message |
rajandhla
Active User
.jpg)
Joined: 18 Oct 2005
Posts: 182
Location: Luton UK
|
|
|
|
Hi Guys,
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 will be pleased with your advices...
Regards,
jai |
|
| Back to top |
|
 |
Nimesh.Srivastava
New User
Joined: 30 Nov 2006
Posts: 78
Location: SINGAPORE
|
|
|
|
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
Thanks
Nimesh |
|
| Back to top |
|
|
|
|
