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 vote365 views1 answer
Sql date d'aujourd'hui
SQL
0 vote338 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote345 views1 answer
Mysql add comment to column
SQL
3 votes328 views1 answer
What is having clause
SQL
0 vote383 views1 answer
Python sql last insertend
SQL
1 vote349 views1 answer
Rermove categories woocommerce sql
SQL
0 vote372 views1 answer
Mysql locate
SQL
4 votes306 views1 answer
Install postgres 12 on ubuntu
SQL
24 votes384 views5 answers
List mysql users
SQL
0 vote387 views1 answer
Drop index in sql
SQL