SQLite Forum

select * from t; -- but don't want virtual columns
Login
I get that difference Keith but in what way would it be different to last_updated as a non-virtual column? I'm assuming it would take up the same space in the db so what is the purpose of STORED?

PS I obviously missed the hidden column because I was using  table_info rather than table_xinfo. I just noticed that table_info doesn't even list the virtual columns. I don't know how I missed that.