SET NOCOUNT ON

SELECT * INTO ##my_INFO_SCHEMA_Cols 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE 1=0

DECLARE myCursor99 CURSOR
FOR
SELECT name FROM sys.databases WHERE state_desc = 'ONLINE'

DECLARE @name varchar(256), @sql varchar(8000)

OPEN myCursor99

FETCH NEXT FROM myCursor99 INTO @name
SET @sql = 'SET NOCOUNT ON; INSERT INTO ##my_INFO_SCHEMA_Cols SELECT * FROM ' + @name + '.information_schema.columns;'
EXEC(@sql)

WHILE @@FETCH_STATUS = 0
  BEGIN
		FETCH NEXT FROM myCursor99 INTO @name
		SET @sql = 'INSERT INTO ##my_INFO_SCHEMA_Cols SELECT * FROM ' + @name + '.information_schema.columns;'
		EXEC(@sql)
  END

CLOSE myCursor99
DEALLOCATE myCursor99

SELECT * FROM ##my_INFO_SCHEMA_Cols 

DROP TABLE ##my_INFO_SCHEMA_Cols
GO