Re: alter column type

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461