Diagrams can do this, but I don't have the time to sit down and arrange all the little boxes so that they fit on pages. I was able, some time ago, to make a list of my tables with their columns and the column's data types through a query (I think). Afterwards I was able to copy and paste it into excel for printing. Again, I THINK I did it this way, but who knows, I've slept since then.
~Steve http://lanctr.com/ -----Original Message----- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:02 PM To: CF-Talk Subject: Re: OT: Printing Database Structure >Do any of you know how I can print all the table names, columns in the > tables, and data types of the columns from within MS SQL Server Mgmnt > Studio? Could creating a diagram with all the tables on it help here? This can show all tables, column data and relationships. Diagrams can be printed.. Dominic On 25/04/2008, Steve Good <[EMAIL PROTECTED]> wrote: > I did this once before, but forgot how I did it, and can't figure out how I > found the answer either. > > > > Do any of you know how I can print all the table names, columns in the > tables, and data types of the columns from within MS SQL Server Mgmnt > Studio? > > > > Thanks. > > > > ~Steve > > http://lanctr.com/ > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
