Add New Column on the Table (Sqlite)

[telco]

Hi everyone.. can i ask help how can i add new Column on a specific Table with using sqlite2? Just incase i already create the table when the db is not yet exist.. now i comeup to add new column if its posible.. i try alter but not work? is sqlite2 allowed to do it?
Thanks for anyone can help.. Thank you

[Ulrich]

Use command ALTER TABLE ADD COLUMN.

ALTER TABLE table-name ADD COLUMN new-column-definiton;

Ulrich

[telco]

anyway i used sqlite 2.0
Thanks ulrich iwill do a reseach..

[Ulrich]

If you cannot perform the command for any reason, then do a dump of the database, and make the change in the SQL file, then import it as a new database. I am not sure why you need to stay with a format over a decade old when AutoPlay Media Studio supports a newer version.

Ulrich

[telco]

Thanks ulrich.. i see that theresqlite3.7.6.2 but cant find any good download link of it.. is that free?