Hi all,

I trying to find an easy way to print out all of the tables and their structures in SQL Server Enterprise Manager for easy reference when programming SQL in VC++.

TIA..

Jim

You can script the database up as one of the export functions - if i recall correclty - this will give you the structure. For the data, just do a SELECT * in Query Analyser and then print your results.

Thanks Greg, I found the "Generate Script" and have used that, just thought there might have been a little better printout of the Table structure.

Thanks,

Jim

Hi Jim,

You can also create a new Diagram which you'll find under your database in the Enterprise Manager, right above Tables. Right-click and choose New Database Diagram.

A Diagram allows you to add one or more tables (visually) to a designer surface. You'll be able to see table names, column names, relations, data types etc. If you want more details about a table, right click it and choose Table View | Custom and then right-click again and choose Table View | Modify Custom to select the information you want to see.
Changes you make to the table and relations will be applied to the underlying tables when you save the Diagram.

Be prepared that the Print functionality is a bit buggy. Expect the paper orientation to switch between Portrait and Landscape at will, for example ;)

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks Imar,

I'll give that a try and see if it's any better than reading script.

Jim