SQL Data Printing

  • When you are in enterprise manager -design view is there an easy way to print all the fields and titles in the output ? I have over 40 fields .

    Thanks.Rocko..

  • Right click Diagrams in your database --> New database diagrams --> following wizard to add your table into diagrams. Right click table --> Table View --> Standard --> Print.

  • What do you do when you are using Views ?

    They do not show up in diagrams and I am not

    sure how you print a sample of the data.

    Do I need or can I create a new table from a view ?

  • Run "select * from INFORMATION_SCHEMA.VIEW_COLUMN_USAGE where view_name like '%yourviewname%'" from QA and copy, paste the result into Word document and print out.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply