SchemaInSight

Most code generation code is intended for generating data-access code. There doesn't seem to be any simple (or free) code for accessing a database and enumerating the database objects.

The database objects that can be accessed using the SchemaInSight tool include:

The database's themselves.
The database tables and views.
Stored procedure parameters, and results. At least for simple stored procedures.

In the future I would like to extend it to include functions, custom types and anything else I can't think of right now.