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

10 votes202 views6 answers
Mysql delete duplicates
SQL
13 votes227 views3 answers
List all the tables in sql
SQL
1 vote196 views1 answer
Apex select list ORA-20999
SQL
1 vote189 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote201 views1 answer
Pl/pgsql declare variable
SQL
0 vote211 views1 answer
Transaction and commit trong sql server
SQL
0 vote187 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote199 views1 answer
Postgres declare variable
SQL
0 vote190 views1 answer
Compare if is null sql
SQL
1 vote220 views1 answer
How to delay stored procedure execution in sql server
SQL