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 vote117 views2 answers
Find nth highest salary of an employee
SQL
1 vote107 views1 answer
Mysql pretty date format
SQL
1 vote214 views3 answers
Create table from existing table in sql
SQL
1 vote126 views2 answers
Drop table if exists test
SQL
0 vote102 views1 answer
Sql select all tables from database change url
SQL
0 vote116 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
2 votes105 views1 answer
Compare date in sql
SQL
0 vote57 views1 answer
Delete all rows from table sqlite
SQL
13 votes107 views2 answers
Oracle inner join
SQL
22 votes113 views6 answers
Create sql table
SQL