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 vote271 views1 answer
Can we drop a primary key
SQL
0 vote296 views1 answer
SQL SELECT-Klausel
SQL
0 vote310 views1 answer
Express api ith mysql data
SQL
0 vote345 views1 answer
Mysql convert charset
SQL
1 vote285 views1 answer
Sample in sql
SQL
0 vote280 views1 answer
Take sql dump in to file
SQL
0 vote316 views2 answers
Mysql calcular idade
SQL
2 votes328 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote288 views1 answer
Kotlin sqlite delete row
SQL
0 vote335 views1 answer
Mysql create index lost connection
SQL