## Try table_xinfo()
``` sql
SELECT * FROM pragma_table_xinfo('tablename')
```
The virtual column gets attribute 'hidden'.
## Example
```shell
sqlite3 test.db \
"CREATE TABLE t1 ( \
id INTEGER PRIMARY KEY NOT NULL, \
a INTEGER, \
b INTEGER, \
c INTEGER GENERATED ALWAYS AS (a * b) VIRTUAL
)" \
".mode column" \
". echo on" \
"SELECT * FROM pragma_table_xinfo('t1')"
cid name type notnull dflt_value pk hidden
--- ---- ------------------------ ------- ---------- -- ------
0 id INTEGER 1 1 0
1 a INTEGER 0 0 0
2 b INTEGER 0 0 0
3 c INTEGER GENERATED ALWAYS 0 0 2
```
~~~
--
Regards,
Kees Nuyt
~~~