SQLite, alter table
lazarus / 16-Databases

----------------------------------------------------------------------
mrdebug · 2007-10-31 14:14

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;

----------------------------------------------------------------------
LuizAmérico · 2007-10-31 18:38

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

Only valid for TSqlite3Dataset