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 vote268 views1 answer
Oracle sql first day of year
SQL
0 vote248 views1 answer
Postgres call view
SQL
1 vote249 views1 answer
Error code 1055
SQL
0 vote245 views1 answer
Oracle list index on table
SQL
1 vote266 views1 answer
Pl sql insert into table
SQL
0 vote268 views1 answer
Datagrip execute procedure
SQL
0 vote264 views1 answer
Possgress drop if exists view
SQL
0 vote270 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
7 votes262 views6 answers
Group_concat in mysql
SQL
0 vote257 views1 answer
Create mysql pool connection python flask
SQL