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 vote246 views1 answer
Get duplicate entry sql
SQL
1 vote260 views2 answers
String to date postgres
SQL
1 vote253 views2 answers
Postgresql backup and restore globals and data
SQL
25 votes280 views3 answers
How to use a database to see tables mysql
SQL
4 votes216 views1 answer
Oracle sleep
SQL
0 vote266 views1 answer
Longtext sql
SQL
-2 votes261 views1 answer
Create trigger syntax
SQL
0 vote271 views3 answers
Database restoring error
SQL
0 vote227 views1 answer
FindAllBy
SQL
5 votes319 views3 answers
Create function in postgresql
SQL