In message <[EMAIL PROTECTED]>, Real_Man <[EMAIL PROTECTED]> writes >HI all, > >May I know how to determine a schema of any given database in MySQL ? >I have this database I created, >Database A with tables: >-Table 1 (6 fields) >-Table 2 (8 fiels) >-Table 3 (3 fields) >-Table 4 (4 fields) > >How would this schema look like ? >thank you so much... > >H
It can be done in Visio, although I have never got that to work. That gives a schema like this http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html with the relationships included. To get a schema of individual tables, use the SQL command SHOW CREATE TABLE table1; -- Pete Clark Sunny Andalucia http://www.hotcosta.com/comm_1.htm
