Select col from sys.tables?

[ixzh]

Execution fails with "SQLite.SQLiteException("no such table: sys.tables")". Any documentation on cross tables select?

[quinnj]

What is "cross tables select"? If you're trying to query system tables, you can do, for example:

using Tables, SQLite, DBInterface
tbl = DBInterface.execute(db, "select * from sqlite_master") |> columntabe

[ixzh]

yes I was to select all tables containing a specific column. sqlite_master is the way thanks will close.😂