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

4 votes145 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote172 views3 answers
Join
SQL
-1 vote160 views1 answer
Mysql select all columns and specific fields as
SQL
6 votes173 views2 answers
How to get yesterday date in mysql
SQL
0 vote157 views1 answer
Mysql update from select on same table
SQL
16 votes148 views1 answer
Mysql reset auto increment value
SQL
1 vote155 views1 answer
Oracle create program if no exists
SQL
1 vote174 views1 answer
Oracle compile schema
SQL
11 votes152 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote154 views1 answer
Mysql select smaller of two values
SQL