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 vote202 views1 answer
Migration graphql
SQL
2 votes204 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote189 views1 answer
Adding primery key constraint to a column
SQL
0 vote173 views1 answer
Sql comparison operators
SQL
0 vote184 views1 answer
Procedure excute monthly oracle
SQL
1 vote202 views1 answer
Add current timestamp in mysql
SQL
14 votes192 views2 answers
Install mysqldump
SQL
11 votes174 views2 answers
Having clause
SQL
3 votes181 views1 answer
Oracle list dates without weekends
SQL
0 vote231 views1 answer
Sql select without column name
SQL