SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 06:00 AM
| ||||
| ||||
 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      |
|
04-10-2008, 06:00 AM
| ||||
| ||||
| 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@pervasive.com 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 |
 |
« savepoints
|
Kernel 2.4->2.6 upgrade results in PANIC: could not locate a validcheckpoint record »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 09:58 AM.
