which db

-- Then for specific tables, you can see which databases they exist in:
SELECT db, table_name
FROM (
SELECT 'COMET_US_REF' AS db, name AS table_name FROM COMET_US_REF.dbo.sysobjects WHERE type = 'U'
UNION ALL
SELECT 'GLOBAL_COMET_US1' AS db, name AS table_name FROM GLOBAL_COMET_US1.dbo.sysobjects WHERE type = 'U'
UNION ALL
SELECT 'GLOBAL_COMET_US2' AS db, name AS table_name FROM GLOBAL_COMET_US2.dbo.sysobjects WHERE type = 'U'
UNION ALL
SELECT 'GLOBAL_COMET_US3' AS db, name AS table_name FROM GLOBAL_COMET_US3.dbo.sysobjects WHERE type = 'U'
) all_tables
WHERE table_name = 'your_table_name' -- replace with actual table name
ORDER BY db;