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 vote123 views1 answer
Oracle compile schema
SQL
0 vote106 views1 answer
Mysql identified by syntax error
SQL
2 votes113 views2 answers
Storing timezones in postgres
SQL
0 vote145 views1 answer
Mysql show foreign keys column
SQL
0 vote154 views1 answer
Add user mysql wordpress
SQL
1 vote109 views2 answers
Mysql join two tables
SQL
-1 vote105 views1 answer
Select first rows postgresql
SQL
0 vote130 views2 answers
While mysql
SQL
-1 vote116 views3 answers
Psql get last rows
SQL
-1 vote105 views2 answers
Postgres autoincrement primary key
SQL