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

0 vote171 views1 answer
Mysql timeout 30 seconds
SQL
0 vote194 views2 answers
Check mysql timezone
SQL
0 vote224 views1 answer
Sql server rtrim everything after character
SQL
-1 vote211 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
-1 vote209 views3 answers
Error mysql shutdown unexpectedly
SQL
9 votes191 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
2 votes211 views1 answer
Ssh mysql port forwarding
SQL
5 votes206 views1 answer
Mysql count newlines in field
SQL
1 vote173 views1 answer
Insert into sql
SQL
5 votes214 views4 answers
Upload database mysql command line
SQL