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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
