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

2 votes217 views1 answer
SQL column name Postgre
SQL
0 vote212 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote203 views1 answer
Mod function example
SQL
6 votes193 views4 answers
Delete table sqlite
SQL
0 vote295 views1 answer
Mysql select random rows large table
SQL
0 vote235 views1 answer
How to find symmetric pairs in sql
SQL
57 votes605 views6 answers
Mysql alter table add column
SQL
11 votes224 views5 answers
Sql server reset identity
SQL
17 votes212 views3 answers
How to change a collumn name in sql
SQL
7 votes247 views5 answers
Sql remove spaces
SQL