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 vote138 views1 answer
What is SQL data store?
SQL
0 vote128 views1 answer
Sqlite3 now
SQL
4 votes191 views1 answer
Sql select limit range
SQL
0 vote157 views1 answer
Declaring variables in pl sql
SQL
0 vote127 views1 answer
Create new table pl sql
SQL
0 vote139 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote138 views1 answer
Sql sort ages
SQL
0 vote138 views1 answer
Copy value from one column to another postgres
SQL
0 vote131 views1 answer
Sql gather statistics to increase performance
SQL
0 vote135 views1 answer
Delete insert record in sql server
SQL