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 vote241 views1 answer
Oracle truncate partition
SQL
1 vote237 views2 answers
Pad zero sql server
SQL
0 vote240 views1 answer
Change permission to database mysql
SQL
11 votes216 views2 answers
Sql rank
SQL
9 votes236 views1 answer
No sql
SQL
0 vote242 views1 answer
Sql missing values
SQL
0 vote225 views1 answer
Laravel eloquent get generated sql
SQL
0 vote236 views1 answer
Mysql sum with group by
SQL
2 votes236 views1 answer
How to get weekday from old date in sql
SQL
0 vote237 views2 answers
Script all indexes in a database
SQL