Lazarus

Programming => Databases => Topic started by: mrdebug on October 31, 2007, 03:14:14 pm

Title: SQLite, alter table
Post by: mrdebug on October 31, 2007, 03:14:14 pm

Can I run a query like this with SQLite?
What is the proper syntax?

Code: [Select]


alter table Anagrafica add column if not exists id_anagrafica Integer;


Title: RE: SQLite, alter table
Post by: LuizAmérico on October 31, 2007, 07:38:02 pm

See http://www.sqlite.org/lang_altertable.html

Only valid for TSqlite3Dataset