Barry Parkin barryparkin

## (sqlite) Show SQLite tables, indexes, etc...
SELECT *
FROM sqlite_master;

## (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}};
	SELECT DISTINCT TABLE_NAME
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE COLUMN_NAME like '%{{fieldname}}%'
	AND TABLE_SCHEMA = {{Database}};