Check if column exists in a table across all databases - SQL Server

check_column_in_table_for_all_databases.sql

DECLARE @cmd nvarchar(2000)
SET @cmd = N'USE [?] IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ''TABLE_NAME_HERE''
AND COLUMN_NAME = ''COLUMN_NAME_HERE'')
BEGIN
SELECT DB_NAME() AS ''Database'', ''TRUE'' AS ''Exists''
END
ELSE SELECT DB_NAME() AS ''Database'', ''FALSE'' AS ''Exists'''
EXEC sp_MSforeachdb @command1 = @cmd;