SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency%' group by TABLE_SCHEMA select agency_id from #Request.prefix_db_lookup#.Agency where status='active' ORDER BY agency_id SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency_179%' GROUP BY TABLE_NAME SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%#Request.prefix_db_agency#%' AND TABLE_NAME = '#GetallTables.TABLE_NAME#' GROUP BY TABLE_NAME CREATE TABLE #Request.prefix_db_agency#.#TABLE_NAME# LIKE agency_179.#TABLE_NAME#