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 vote115 views1 answer
Database springboot
SQL
3 votes117 views3 answers
How to add month in update sql
SQL
1 vote128 views1 answer
Sql how to duplicate a table
SQL
0 vote143 views1 answer
Postgres list all triggers
SQL
0 vote176 views1 answer
Postgres rename database
SQL
4 votes105 views4 answers
Print pl sql
SQL
3 votes117 views1 answer
Sql cast to integer
SQL
0 vote127 views1 answer
SQL column name Oracle
SQL
0 vote146 views1 answer
Install mysql on bash
SQL
0 vote106 views1 answer
Learn sqlite dart
SQL