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 vote189 views1 answer
Print boolean in plsql
SQL
12 votes243 views10 answers
Google
SQL
3 votes185 views5 answers
Mysql get last inserted id
SQL
0 vote207 views1 answer
Tsql pad left
SQL
2 votes228 views2 answers
Mysql write into table
SQL
3 votes182 views2 answers
Oracle grants
SQL
0 vote184 views1 answer
Postgres drop type
SQL
1 vote185 views1 answer
Sql group by error
SQL
0 vote223 views1 answer
Mssql last day of month
SQL
1 vote299 views1 answer
Oracle current sequence value
SQL