Re: MySQL DB Schema
| From: | David Otton | Date: | Tue, 18 Feb 2003 17:39:27 +0000 |
| Subject: | Re: MySQL DB Schema | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-136040@lists.php.net to get a copy of this message | ||
On Tue, 18 Feb 2003 09:23:52 -0800, you wrote:
>Greetings all,
>
>Is there an easy way to pull out the schema of a MySQL for viewing??
You want the tables and the relationships between them? Not easy to get
the links because of the lack of foreign keys in MySQL.
If you want a table, "DESC tablename".
If you want to capture the create statements for the tables, "mysqldump
-d databasename > filename.sql"