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 vote147 views2 answers
Extract weekday from date in sql
SQL
7 votes148 views1 answer
Query postgres delete duplicates
SQL
4 votes152 views3 answers
Mysql modify foreign key
SQL
6 votes232 views1 answer
Sql insert values into table
SQL
0 vote180 views2 answers
Check if sql temp table exists
SQL
1 vote139 views2 answers
Drop function in sql
SQL
2 votes190 views1 answer
Creating a view SQL
SQL
31 votes140 views1 answer
Postgresql add column with constraint
SQL
0 vote147 views1 answer
List all functions and procedures in postgres query
SQL
1 vote203 views1 answer
Size of all tables in a schema oracle
SQL