Getting All Columns from entire Database in SQL Server

Here we can get all columns from all tables from entire database.

? – Indicates the name of database.

sp_msforeachdb 'select "?" AS dbName, * from [?].sys.columns