There is a non-logicality of having "pragma table_info(my_table)" : - answering like a select, - but being not usable as a "select", nor queriable by a "select".
Other databases seem more logical on this practical matter. Multi-motor tools, like dbeaver, have currently much less good support of "database diagram" when dealing with SQLite. ==> Is it the reason ? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users