#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    3
    Rep Power
    0

    Table schema to paper


    Is there an easy and FREE way to print out on paper, or otherwise copy/paste onto a document, my table schema?
  2. #2
  3. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,316
    Rep Power
    7171
    What sort of representation of the schema do you want to print? MySQL Workbench can do a graphical representation of a schema.
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    3
    Rep Power
    0
    I'm just looking for simple table structure:

    Field name, Data type, Description.

    It looks like phpmyadmin does this through the "data dictionary" link so I may use this if there isn't anything else suitable. Do you have any suggestions of your own?

    I'm looking to replace my current method of handwriting and keeping pages of table info.
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    use mysqldump to generate the CREATE TABLE statements
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    3
    Rep Power
    0
    r937, I considered this but I decided on a better approach. I'm going to create a small script on my server that will fetch the information I need and generate a nice looking html report on the fly. Then I can just print that out from the browser. It means a little bit of leg work to create the script, but in the end it will look nicer and result in less work for me each time I need to update my reports. Thanks for your comments and help, r937 & E-Oreo.

IMN logo majestic logo threadwatch logo seochat tools logo