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 vote311 views1 answer
Sql get table last modified time
SQL
0 vote322 views1 answer
Mysql find missing values
SQL
0 vote342 views1 answer
Separator mysql
SQL
23 votes324 views3 answers
Mysqldump
SQL
0 vote312 views1 answer
Time mysql w3
SQL
1 vote326 views1 answer
Mysql dump specific tables
SQL
0 vote276 views1 answer
Oracle function select into
SQL
0 vote318 views1 answer
Output to file mysql
SQL
0 vote320 views1 answer
Modificar tipo de dato sql server
SQL
0 vote311 views1 answer
Sql examples from your work
SQL