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 vote213 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
16 votes214 views1 answer
Sql comment'
SQL
93 votes253 views4 answers
Create database postgres
SQL
0 vote213 views1 answer
Sqlcmd no headers
SQL
2 votes206 views1 answer
Insert from table tsql
SQL
2 votes246 views1 answer
How to select from mssql
SQL
2 votes227 views1 answer
Oracle apex who is connected
SQL
0 vote227 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote211 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote198 views1 answer
Sql examples from your work
SQL