Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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 by dataedo.com #
 
PREVIOUS NEXT
Tagged: #mariadb #search #columns
ADD COMMENT
Topic
Name
4+8 =