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

34 votes206 views6 answers
Alter table add foreign key mysql
SQL
0 vote143 views1 answer
Mysql update sequence with order by
SQL
5 votes149 views1 answer
Alter table add comment oracle
SQL
0 vote140 views1 answer
Using GROUP BY in MySQL Join Table
SQL
1 vote153 views1 answer
Oracle add proxy
SQL
1 vote149 views2 answers
Mysql current user
SQL
1 vote151 views1 answer
Postgres get timestamp
SQL
1 vote152 views1 answer
Psql show with user is logged in
SQL
0 vote148 views1 answer
Mysql concat and use as where column
SQL
0 vote164 views1 answer
Create dump file mysql workbench
SQL