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

5 votes418 views1 answer
Oracle get ddl
SQL
1 vote400 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote355 views1 answer
Get employees if not contains in sql
SQL
0 vote356 views1 answer
Oracle running queries sql
SQL
0 vote399 views1 answer
Delete from table where length sql
SQL
1 vote405 views1 answer
Floor function in sql oracle
SQL
79 votes638 views6 answers
Grepper code
SQL
0 vote343 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote347 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote345 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL