Print hardcopy of table structure

I've just started working with SQL Server Express, and would like to print out a report listing the properties (Ie. field names, data ttypes, length, field description, etc.) of each of the tables in my database.
How do I do this?

The best way would be to use the INFORMATION_SCHEMA views and in this case the one that presents the columns definitions:

SELECT * FROM
INFORMATION_SCHEMA.COLUMNS

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||Thanks very much for your help!