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 vote236 views1 answer
Mysql remove last character
SQL
4 votes221 views1 answer
Postgresql create table with index
SQL
2 votes165 views1 answer
How to delete columns in sql
SQL
0 vote187 views1 answer
Linked server delete openquery
SQL
0 vote181 views1 answer
Sql get user account
SQL
2 votes125 views1 answer
Sql view column data type
SQL
8 votes183 views2 answers
Replace string value in sql
SQL
0 vote171 views1 answer
Postgresql get current user name
SQL
2 votes175 views3 answers
How to pass password mysql command line
SQL
25 votes194 views4 answers
Sqlserver add column
SQL