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

3 votes283 views3 answers
Print in pl sql
SQL
0 vote320 views1 answer
Group by 15 minute interval sql server
SQL
1 vote291 views1 answer
Mysql select month and year
SQL
10 votes263 views1 answer
Oracle view dependencies
SQL
0 vote305 views1 answer
How to find username and password in oracle 18c
SQL
0 vote297 views1 answer
Sum value by month sql
SQL
0 vote345 views1 answer
FIND most frequent word in sql server
SQL
1 vote301 views1 answer
Oracle convert run duration to number
SQL
2 votes301 views1 answer
Sql create database
SQL
0 vote310 views1 answer
Sql server change schema of a table
SQL