RE: Generate 'create table' sql

[Rolando Edwards]

You are better off using mysqldump

mysqldump -h... -u... -p... <DatabaseName> --no-data --triggers

This will output all CREATE TABLE statements for every table in the Database

-----Original Message-----
From: Miller, Lachlan S (DTF) [mailto:Miller.Lachlan@stripped]
Sent: Monday, December 03, 2007 11:44 PM
To: gui-tools@stripped
Subject: Generate 'create table' sql

Hi All

With query browser I can select a table from the schema tab of the sidebar and use crtl+c
to copy the create table sql to the clipboard.  Is there a built in feature in either
query browser or administrator to generate the create table sql for multiple tables in
one click?  Ideally I would like to be able to generate the sql for an entire schema
including the create database and all associated tables.

Thx for any suggestions

Regards

Lachlan