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 vote291 views1 answer
Geopoint from json mysql function
SQL
0 vote283 views2 answers
Mysql row_number() example
SQL
8 votes265 views3 answers
Mysql alter table add index
SQL
0 vote307 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
2 votes234 views1 answer
Oracle sql drop column if exists
SQL
0 vote301 views1 answer
Doctors appointment
SQL
1 vote285 views1 answer
Psql connections
SQL
0 vote284 views1 answer
Create tables from xsd to sql server database c#
SQL
3 votes277 views2 answers
Plsql print
SQL
0 vote288 views5 answers
Select concat alter table mysql
SQL