Mariadb search columns

select tab.table_schema as database_name,
    tab.table_name
from information_schema.tables as tab
    inner join information_schema.columns as col
        on col.table_schema = tab.table_schema
            and col.table_name = tab.table_name
            and column_name = 'your column name'
where tab.table_type = 'BASE TABLE'
order by tab.table_schema,
    tab.table_name;

Source: dataedo.com

Similar codes

1 vote267 views1 answer
Sql sort column by date
SQL
0 vote257 views1 answer
Add plugins to mysql workbench
SQL
0 vote277 views1 answer
Postgres drop type
SQL
2 votes287 views1 answer
Oracle sql merge
SQL
3 votes287 views1 answer
Postgres kill running query
SQL
0 vote309 views1 answer
Oracle winter time change
SQL
0 vote283 views1 answer
Sql date between one week
SQL
7 votes259 views2 answers
Get database size mysql
SQL
0 vote261 views1 answer
Ffeathers express mysql application users login
SQL
13 votes267 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL