Re: [sqlite] How can I rename a column without ALTER COLUMN Command

[Alex Charyna]

Here's what I might do, I'd be curious of the other's answers.

You could use the .dump command, redirect it into a flat file
Use sed to fix the field name in the file.
Delete the old table.
Then load it back in using the corrected dump file.

-alex

On Apr 7, 2006, at 10: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