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 vote316 views1 answer
Insert or update cassandra
SQL
1 vote338 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote324 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote326 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote380 views2 answers
Wordpress change url after migration mysql query
SQL
2 votes353 views1 answer
Select sid oracle
SQL
1 vote339 views2 answers
Mysql filter by date mount
SQL
0 vote297 views0 answer
SQL
0 vote384 views1 answer
For row in sql database python loop
SQL
0 vote351 views1 answer
Oracle drop type
SQL