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 vote373 views1 answer
Pl/sql how to delete a trigger
SQL
6 votes402 views3 answers
Check if string contains substring sql
SQL
0 vote358 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote337 views1 answer
Mysql concat and use as where column
SQL
0 vote335 views2 answers
How to start postgresql laravel
SQL
0 vote384 views1 answer
MySQL - Enabling the Event Scheduler
SQL
8 votes333 views5 answers
Alter table add column with default value
SQL
0 vote362 views2 answers
Homebrew nysql launch
SQL
2 votes348 views5 answers
SQL trigger
SQL
6 votes350 views1 answer
T-sql test if table exists
SQL