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 vote146 views1 answer
Is not numeric sql
SQL
5 votes158 views3 answers
Show indexes mysql
SQL
0 vote181 views1 answer
Parent and child link in mysql
SQL
0 vote137 views1 answer
Increase speed of like queries postgres
SQL
0 vote125 views1 answer
Order by monthly in sql
SQL
0 vote134 views1 answer
Query to get all primary keys and foreign key
SQL
8 votes156 views3 answers
Find table for column name in sql
SQL
8 votes126 views2 answers
Phpmyadmin default password
SQL
2 votes93 views1 answer
Sql select min value from multiple columns
SQL
2 votes161 views1 answer
Insert from table tsql
SQL