Looking for the best way to programmatically generate a list of all the databases on a particular SQL Server box ... and for each database, include a list of tables ... and for each table ... include a list of columns with column info.

How about rolling up the information? Ideally I'd like to generate something I can just cut & past into excel that shows everything grouped correctly (basically how I mentioned it in my previous postings) ... so for every db, there would be a list of tables ... and for ea. table, a list of columns.

Not sure at all how to do this (but i know its possible). Any ideas on how to formulate it?