MySQL Forums :: Information Schema :: Creating a data dictionary

You'll have too loop through your databases and tables, then execute "show create table TABLE1"

connect
mysql "show databases";
while (rows)
{
mysql "show tables"
while (rows)
{
mysql "show create table TABLE1"
}
}




James Illingworth wrote:
> Hi
>
> I'm trying to create a nice printable data
> dictionary from my database which includes all
> fields of each table with attributes and indices.
> I have a query to do this in MS SQL server, but
> can't figure out how to do it with MySQL.
>
> Thanks,
> James