Select *
From INFORMATION_SCHEMA.COLUMNS

DECLARE @SQL NVARCHAR(MAX)
SELECT @SQL = REPLACE(
					CAST(
							(
								SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +
								'SELECT * FROM INFORMATION_SCHEMA.COLUMNS' + CHAR(13) + CHAR(10)										
								FROM sys.databases
								FOR XML PATH('')
							) 
						AS NVARCHAR(MAX)
					),
				' & # x 0 D ; ',CHAR(13) + CHAR(10)
				)
SELECT @SQL
--EXECUTE sp_executesql @SQL

DECLARE @SQL NVARCHAR(MAX)
SELECT @SQL = substring(REPLACE(
					CAST(
							(
								SELECT ' UNION SELECT * FROM  ' + QUOTENAME(name) 
								--Select *
								--'SELECT * FROM '+ QUOTENAME(name)
								+'.'+'INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME like ''FindMe''' 									
								FROM sys.databases
								FOR XML PATH('')
							) 
						AS NVARCHAR(MAX)
					),
				'
',CHAR(13) + CHAR(10)
				),8,8000)
--SELECT @SQL
EXECUTE sp_executesql @SQL

DECLARE @SQL NVARCHAR(MAX)
SELECT @SQL = substring(REPLACE(
					CAST(
							(
								SELECT ' UNION SELECT * FROM  ' + QUOTENAME(name) 
								--Select *
								--'SELECT * FROM '+ QUOTENAME(name)
								+'.'+'INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME like ''findme''' 									
								FROM sys.databases
								FOR XML PATH('')
							) 
						AS NVARCHAR(MAX)
					),
				'
',+ CHAR(10)
				),8,8000)
--SELECT @SQL
EXECUTE sp_executesql @SQL