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

6 votes254 views2 answers
Mysql execute file
SQL
3 votes191 views2 answers
Mysql sum with condition
SQL
0 vote235 views1 answer
Sql server order by nulls last
SQL
0 vote241 views1 answer
Add multiple field in table sql
SQL
0 vote231 views1 answer
Sqlite update where exists
SQL
0 vote227 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote239 views1 answer
Max mysql
SQL
1 vote252 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote236 views1 answer
Using GROUP BY in MySQL Join Table
SQL
1 vote244 views1 answer
How to see logical reads in sql server
SQL