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 vote162 views1 answer
Mysql multiple count
SQL
0 vote262 views1 answer
Linux upload database to mysql
SQL
1 vote184 views1 answer
Mysql month name extract
SQL
0 vote185 views2 answers
List all constraints in postgres
SQL
1 vote169 views2 answers
Grab part of a string sql
SQL
4 votes254 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
50 votes251 views4 answers
Sql alter type of column
SQL
0 vote181 views1 answer
Sqlalchemy one column of two has to be not null
SQL
1 vote175 views1 answer
Input in mysql
SQL
2 votes299 views2 answers
MySql FULL OUTER JOIN
SQL