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 vote358 views1 answer
Providername system.data. mysql
SQL
0 vote321 views1 answer
Oracle sql generate list of days
SQL
1 vote368 views1 answer
Sql server if exists update else insert
SQL
3 votes479 views9 answers
Linq to sql converter online
SQL
2 votes338 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
5 votes325 views3 answers
Day of week postgresql
SQL
7 votes319 views1 answer
Forge server hosting
SQL
1 vote341 views1 answer
Mysql show attributes of a table
SQL
0 vote418 views1 answer
Mysql get nested records
SQL
0 vote335 views1 answer
Sql select min
SQL