Professional Web Applications Themes

how to prep database schema - MySQL

Hi I ve a huge database created in MySQL by someone else. now i want to view all the tables and their relationships so tht i can design the queries. Can you plitz tell me how can i view the tables n their realtionships. thanx pallavi...

  1. #1

    Default how to prep database schema

    Hi
    I ve a huge database created in MySQL by someone else. now i want to
    view all the tables and their relationships so tht i can design the
    queries. Can you plitz tell me how can i view the tables n their
    realtionships.
    thanx
    pallavi

    pallabi2k@gmail.com Guest

  2. #2

    Default Re: how to prep database schema

    [email]pallabi2k[/email] wrote:
    > I ve a huge database created in MySQL by someone else. now i want to
    > view all the tables and their relationships so tht i can design the
    > queries. Can you plitz tell me how can i view the tables n their
    > realtionships.
    DBDesigner 4 can examine an existing database and produce a diagram of
    it. [url]http://fabforce.net/dbdesigner4/[/url]

    The same developer is now working on a successor application for MySQL
    AB. It's called MySQL Workbench, but it's still in beta and is somewhat
    unstable so far. [url]http://dev.mysql.com/downloads/workbench/1.0.html[/url]
    Also it lacks doentation as far as I know.

    Regards,
    Bill K.
    Bill Karwin Guest

Similar Threads

  1. Configurable database schema
    By Brian G. in forum Coldfusion Database Access
    Replies: 2
    Last Post: November 22nd, 06:01 PM
  2. Loading Database Schema
    By Scott*e in forum Dreamweaver AppDev
    Replies: 1
    Last Post: April 24th, 05:34 PM
  3. Looking for sample code and database schema
    By Jeff Cochran in forum ASP Database
    Replies: 3
    Last Post: February 23rd, 08:11 PM
  4. Replies: 3
    Last Post: July 11th, 04:26 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139