SQLite Forum

Documentation for Generated Columns missing pragma table_xinfo statement
Login

Documentation for Generated Columns missing pragma table_xinfo statement

(1) By Vedran (phidrho) on 2022-11-09 15:54:41 [source]

Hi,

if we run a

pragma table_info(t1);

where t1 is a table with 'Generated Columns' we get list of only ordinary columns, ie generated column(s) are not displayed, even if STORED option is used.

So, there is a need to use

pragma table_xinfo(t1);

statement to get result that includes all columns - regular and generated (computed) ones.

I think that this behavior should be documented in Generated Columns article, and also in pragma table_xinfo.

(2) By Richard Hipp (drh) on 2022-11-09 20:14:22 in reply to 1 [link] [source]

The documentation has been updated as suggested.