Find column in table across databases

DECLARE @command varchar(1000)

set @command=’USE ? SELECT
Table_Catalog
,Table_Schema
,Table_Name
,Column_Name
,Data_Type
,Character_Maximum_Length
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = ”UL90” order by Table_Catalog’

EXEC sp_MSforeachdb @command

Find objects across databases

Option 1

drop table #SPs
CREATE TABLE #SPs (db_name varchar(100), name varchar(100), object_id int, xtype varchar(10))
EXEC sp_msforeachdb ‘USE [?]; INSERT INTO #SPs select ”?”, name, id, xtype from sys.sysobjects where name = ”SplitChar”’
SELECT * FROM #SPs

Option 2

–IF is for table value function

SELECT name,
QUOTENAME(name)
FROM sys.databases
WHERE
CASE WHEN state_desc = ‘ONLINE’
THEN OBJECT_ID(QUOTENAME(name) + ‘.[dbo].[SplitChar]’ ,’IF’)
END IS NOT NULL