Hi Dennis, I followed your path and managed to rebuild my table. All is well in the land of Roman now. Thanks again, Roman
On Friday 07 April 2006 11:57 am, Dennis Cote wrote: > Roman wrote: > >http://sqlzoo.net/howto/source/z.dir/tip557646/i02create.xml > > > >says that such is not possible > > > >On Friday 07 April 2006 11:39 am, Roman wrote: > >>I know that ALTER TABLE -> ALTER COLUMN is not supported by sqlite3. > >> > >>I misspelled a column name, and I am curious if there is a command to > >>change the name from sqlite3 interface. > >> > >>Thanks, > >>RK > > Roman, > > Try this: > > begin; > create temp table temp_table as select * from bad_table; > drop table bad_table; > create table good_table (.... same as existing with correct column name) > insert into good_table select * from temp_table; > drop table temp_table; > commit; > > You will also need to recreate any indexes on the table after it is > dropped. > > HTH > Dennis Cote