Обсуждение: alter column type
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
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