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
