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 vote166 views1 answer
What is metadata in sql
SQL
0 vote180 views2 answers
Port 5432 is already in use mac
SQL
0 vote152 views1 answer
Get only first row mysql
SQL
0 vote202 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote213 views1 answer
Oracle running queries
SQL
0 vote164 views1 answer
Postgresql like
SQL
0 vote160 views1 answer
Mysql disable query caching
SQL
0 vote156 views2 answers
How to set global time_zone in mysql
SQL
2 votes184 views1 answer
How to show the whole table in sql
SQL
4 votes159 views3 answers
Order by value mysql
SQL