Searching Column Name From Table in Database

select table_name from information_schema.columns group by table_name


select table_name,column_name from information_schema.columns
where column_name like '%MGS_Groupcode%'