Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2004
    Posts
    39

    Unanswered: print the design of a tabel

    Hi,

    I cannot figure out how to print the design of a tabel.
    What I need is to have printed on a paper the list of the columns, data type, length, allow nulls and description for a table.
    thx

  2. #2
    Join Date
    Nov 2004
    Posts
    39
    Also, I cannot figure out how to copy the design of a table into Excel.
    It looks that copy&paste is not working on Enterprise Manager when I select all the columns of my table.

  3. #3
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212
    In Enterprise Manager right click on table name. then: ''All Task''/''Generate SQL Scripts''. In ''Formating'' and ''Options'' tabs mark all you need to display. In ''General'' tab click on ''Preview'' and copy paste table definition. You'll retrieve columns names, data types, indexes... all aboou your table.

  4. #4
    Join Date
    Nov 2004
    Posts
    39
    well, is not exactly what I have expected at.
    What I found is to create a diagram with the table displayed in Custom view. I can print out the diagram but the copy&paste is not working if I want to embadded the definition table into a Word document for example.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd use Excel's Data Import to pull the data I wanted from
    Code:
    SELECT * FROM INFORMATION_SCHEMA.COLUMNS
    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •