SQLITE alter table
lazarus / 16-Databases

----------------------------------------------------------------------
berghem · 2021-02-18 20:41

Hi All
In my application I have to check if in the table exist a column and
if not exists I have to create it

Can you help me?

----------------------------------------------------------------------
af0815 · 2021-02-18 21:02

If you spend more information or code it can be possible.

https://sqlite.org/lang_altertable.html Part 4 descibes th process.
What is your problem ?

https://forum.lazarus.freepascal.org/index.php?topic=47985.0 for
quering the coloums

----------------------------------------------------------------------
Zvoni · 2021-02-19 07:07

Quote from: berghem on February 18, 2021, 09:41:26 pmHi All
In my application I have to check if in the table exist a column and
if not exists I have to create it

Can you help me?
Code: [Select]PRAGMA table_info(MyTableName)

Remember, if you want to alter a Table, which PrimaryKey points to a
Foreign Key in a different child-table, the ALTER-Statement is likely
going to fail.