mariadb search columns

Solutions on MaxInterview for mariadb search columns by the best coders in the world

showing results for - "mariadb search columns"
Juan Diego
16 Jul 2018
1select tab.table_schema as database_name,
2    tab.table_name
3from information_schema.tables as tab
4    inner join information_schema.columns as col
5        on col.table_schema = tab.table_schema
6            and col.table_name = tab.table_name
7            and column_name = 'your column name'
8where tab.table_type = 'BASE TABLE'
9order by tab.table_schema,
10    tab.table_name;
11
similar questions
queries leading to this page
mariadb search columns