Thread: alter column type

alter column type

From
"sandhya"
Date:
Hi..
  If i want to change the datatype of a column in a table.....What are all the thigs i need to take care off.
After somany records insertion if i change the datatype of the column..What will be the effect of it.
Please tell me /give suggestion what needs to be cosider at the time of changing column type of a table.
 
Incase of  int to char/varchar/text/ etc.
What are the different datatypes we should think about?
 
Thank you,
Sandhya
 
 
 
 
 

Re: alter column type

From
"Jim C. Nasby"
Date:
About the only thing you need to consider is that changing the type of a
column will re-write the entire table, and I'm pretty sure it will hold
an exclusive lock during that process.

On Mon, Apr 10, 2006 at 03:13:38PM +0530, sandhya wrote:
> Hi..
>   If i want to change the datatype of a column in a table.....What are all the thigs i need to take care off.
> After somany records insertion if i change the datatype of the column..What will be the effect of it.
> Please tell me /give suggestion what needs to be cosider at the time of changing column type of a table.
>
> Incase of  int to char/varchar/text/ etc.
> What are the different datatypes we should think about?
>
> Thank you,
> Sandhya
>
>
>
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461