(sqlite) Find table in database by field name

(sqlite) Find table in database by field name

SELECT DISTINCT TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME like '%{{fieldname}}%'
    AND TABLE_SCHEMA = {{Database}};

In my case sqlite_master instead of INFORMATION_SCHEMA was available for sqlite3:

SELECT DISTINCT name FROM sqlite_master
WHERE sql like '%fieldname%';

WHERE sql like

can you explain the sql here? it's not any field name right?

Only fieldname has to be included. Query result will show all the tables where there is a column name equal to fieldname.

Only fieldname has to be included

I just realised sqlite_master is a special table where sql is the last column with the CREATE statement text. Thanks !!