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

3 votes129 views1 answer
Sql case update
SQL
0 vote142 views1 answer
Reindex mssql table
SQL
6 votes211 views1 answer
Sql insert values into table
SQL
0 vote138 views1 answer
Select into table variable
SQL
0 vote125 views1 answer
Can we rollback deleted data in sql
SQL
0 vote137 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote124 views1 answer
Power query case when
SQL
0 vote129 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote127 views5 answers
Linq cheat sheet
SQL
-1 vote131 views1 answer
Sql select data from one database and insert into a different database
SQL