RE: Generate 'create table' sql
Rolando Edwards <[email protected]> Tue, 4 Dec 2007 12:15:53 -0500
| Newsgroups | gmane.comp.db.mysql.mycc |
|---|---|
| Message-ID | <E75AB101237A1842B208BDDABE741B28038AA4E6F7@exchange4a.corp.logicworks.net> |
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:[email protected]] Sent: Monday, December 03, 2007 11:44 PM To: [email protected] 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 -- MySQL GUI Tools Mailing List For list archives: http://lists.mysql.com/gui-tools To unsubscribe: http://lists.mysql.com/[email protected]