My thoughts to your thoughts.
Check this out: A webpage that gets all the tables, their column names, column data types and other information from an SQL Server database.