I realize I can copy the results from the panel into another app but I thought I could simply print the results panel directly from query analyzer. Thanks for all the great help!
Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 10:32 AM To: SQL Subject: RE: Print out tables in MS SQL 2000 You can copy and paste/or export the data in the result pain. What you are seeing is a result NOT SQL, there is a difference. Neil -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 15:32 To: SQL Subject: Re: Print out tables in MS SQL 2000 The best way is ERwin. Just kidding. If you're looking for structure and not the actual DDL, the easiest way I've found to print out a database's structure, including relationships, is to create a diagram through Enterprise Manager. Open the diagram and right-click one of your tables. Choose Table View / Modify Custom. Select Column Name, Condensed Type, Nullable, and Default Value as your custom columns and click OK. Right-click the diagram background and choose Select All, then click the Show button on the toolbar (it's the sheet of paper icon next to the magnifying glass) and choose Custom. All of your tables will now appear with the additional columns you selected. Right-click the background again and choose View Page Breaks. Blue lines will now appear to show you where the tables will print. Now you can re-arrange the tables so they don't print in the middle of a page break. If you want to print the DDL, be sure you have clicked in the results pane of Query Analyzer before hitting Print. The Print command will print out the active pane only. Succumb to natural tendencies. Be hateful and boring. -- Today's Fortune "Bosky, Dave" <[EMAIL PROTECTED]> 01/21/2003 09:48 AM Please respond to sql To: SQL <[EMAIL PROTECTED]> cc: Subject: Print out tables in MS SQL 2000 What's the best method of printing out the table structures(fieldname/datatype) of a database? I've tried the print screen method but is there a better way? Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
