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 vote189 views1 answer
Mamp mysql path mac
SQL
0 vote230 views1 answer
Sql anywhere create procedure
SQL
1 vote179 views1 answer
Order by oracle
SQL
1 vote189 views1 answer
Apex ORA-20999
SQL
7 votes180 views6 answers
Group_concat mysql
SQL
0 vote180 views1 answer
R2dbc-postgresqldriver dependency
SQL
17 votes322 views4 answers
Show all tables in oracle
SQL
0 vote198 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote191 views1 answer
Calculate age in sql
SQL
0 vote204 views1 answer
Psql check table fields
SQL