Breaking News: Grepper is joining You.com. Read the official announcement!

mariadb search columns

Black Bug answered on August 23, 2021 Popularity 3/10 Helpfulness 4/10

answer mariadb search columns

mariadb search columns

Comment

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;

Popularity 3/10 Helpfulness 4/10 Language sql

Source: dataedo.com

Tags: mariadb search sql

Link to this answer
Share Copy Link

Contributed on Aug 23 2021

Black Bug

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

mariadb search columns

Contents

More Related Answers

mariadb search columns

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.