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 vote211 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote165 views2 answers
Sql query print strings and int
SQL
0 vote142 views1 answer
Como saber si tengo mysql instalado
SQL
13 votes153 views3 answers
Uninstall mysql centos 7
SQL
0 vote152 views1 answer
Import sql in postgresql
SQL
11 votes151 views3 answers
How to get last row of table in sql
SQL
12 votes153 views4 answers
Mysql version
SQL
1 vote166 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
2 votes162 views1 answer
Sql get the name of user pc
SQL
1 vote161 views2 answers
Limit sqlserver
SQL