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

5 votes302 views1 answer
Update sql user password
SQL
4 votes326 views2 answers
Installing sql on ubuntu
SQL
8 votes468 views4 answers
Convert date to dd/mm/yyyy sql
SQL
2 votes319 views4 answers
Mysql select into new table
SQL
1 vote346 views1 answer
Insert many to many sql
SQL
0 vote320 views1 answer
Two inner joins sql
SQL
0 vote321 views1 answer
Java sql connection
SQL
1 vote331 views1 answer
Oracle check table lock
SQL
0 vote308 views1 answer
Sql query interview questions githu
SQL
0 vote314 views1 answer
Mysql create pool
SQL