If you want to get a list of all the tables in a DB that have a particular column name:

SELECT table_name FROM information_schema.columns WHERE column_name = 'satellite_group_id';