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

1 vote204 views2 answers
Sql server find all foreign keys that reference a column
SQL
12 votes159 views6 answers
Change mysql root password
SQL
13 votes129 views6 answers
Mysql update from select
SQL
0 vote136 views4 answers
Sql year
SQL
0 vote116 views0 answer
SQL
0 vote151 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote143 views1 answer
Sql missing values
SQL
0 vote160 views1 answer
Selecting all columns from table sql database
SQL
17 votes165 views6 answers
MySQL ORDER BY
SQL
0 vote132 views1 answer
Case when with count and combining similar values in sql
SQL