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 vote187 views1 answer
Minecraft duping allowed servers
SQL
24 votes208 views5 answers
List mysql users
SQL
1 vote199 views2 answers
How to check if sql query is correct online
SQL
0 vote265 views2 answers
How to take recent row without limit in mysql
SQL
2 votes239 views1 answer
Sql string starts with
SQL
1 vote205 views1 answer
Age postgres
SQL
3 votes194 views1 answer
Select nextval from sequence sql
SQL
0 vote179 views1 answer
Full syntax inner join
SQL
0 vote230 views1 answer
Mysql last friday of current month
SQL
-1 vote193 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL