There's also the SHOW CREATE TABLE <tablename> sql command:
http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html
According to
http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.23.x
this command is available from 3.23.20 on.
-steve
At 4:39 PM -0400 6/14/02, "Don Vu" <[EMAIL PROTECTED]> wrote:
>if you do mysqldump -d -p -u <USERNAME> <DATABASENAME> > <FILENAME>
>then it will pipe only the CREATE TABLE statements and no insert
>statements into <FILENAME>.
>
>-Don
>
>-----Original Message-----
>From: Erik Price [mailto:[EMAIL PROTECTED]]
>Sent: Friday, June 14, 2002 4:39 PM
>To: Hihn Jason
>Cc: [EMAIL PROTECTED]
>Subject: Re: Reconstructing SQL create table statements
>
>
>
>On Friday, June 14, 2002, at 04:06 PM, Hihn Jason wrote:
>
>> I have a large number of tables that have been created through the
>> years,
>> and I wish to obtain the SQL statements used to create them. I can go
>> through and do it all by hand, but that would take forever. Is there a
>> way
>> to run a script against the database that will generate them for me? If
>> it
>> misses the occasional additional index, then that is fine.
>
>If you have the mysql client programs and are using a Unix machine
>(maybe even Win but I'm not sure) you can use the mysqldump program. It
>is usually located in the "bin" directory of your MySQL distribution.
>Mine is /usr/local/mysql/bin/mysqldump.
>
>Read up on it, it can dump all data from your database and does so with
>the CREATE TABLE statements attached so that the whole thing can
>literally be rebuilt from scratch. Just chop off the contents if you
>only want the CREATE TABLE statements.
>
>
>Erik
>
>
>
>
>----
>
>Erik Price
>Web Developer Temp
>Media Lab, H.H. Brown
>[EMAIL PROTECTED]
>
--
+------------------------------------------------------------------------+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ |
+------------------------------------------------------------------------+
| "If only life would imitate toys." |
| - Ted Raimi, March 2002 |
| - http://www.whoosh.org/issue67/friends67a.html#raimi |
+------------------------------------------------------------------------+
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
