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

7 votes310 views1 answer
Mysql remote connection command line
SQL
0 vote332 views3 answers
Characters found after end of sql statement
SQL
1 vote310 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
5 votes296 views3 answers
Db begintransaction laravel
SQL
7 votes272 views2 answers
Sql server drop temp table if exists
SQL
0 vote283 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
13 votes263 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
2 votes352 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote256 views1 answer
SQL server select to get sum of hours
SQL
7 votes318 views5 answers
Max 3 salary in sql
SQL