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 vote121 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
1 vote110 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote112 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
5 votes115 views6 answers
Sql add days to date
SQL
0 vote136 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
8 votes120 views2 answers
Python simple connect to mysql
SQL
0 vote125 views1 answer
Sql select all records from all tables where not empty
SQL
1 vote139 views1 answer
Postgres install unaccent extension
SQL
0 vote126 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote112 views1 answer
Oracle query archivemode
SQL