Bug #6490 Cannot SHOW CREATE TABLE or DATABASE/SCHEMA
Submitted: 7 Nov 2004 23:43 Modified: 27 Jul 2005 10:00
Reporter: [ name withheld ] Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S4 (Feature request)
Version:1.1.0 Gamma OS:Windows (Windows XP Pro SP2)
Assigned to: CPU Architecture:Any

[7 Nov 2004 23:43] [ name withheld ]
Description:
Query Browser does not seem to support the ability to either "SHOW CREATE TABLE" for 1 or more tables in a database or perform a "SHOW CREATE DATABASE" or "SHOW CREATE SCHEMA" operation on a database.

MySQL CC had the functionality to run the SHOW CREATE TABLE on all selected tables and then dump the results out into a script, this was very handy when developing an application for backing up create table scripts... currently there is no replacement for this it seems.

How to repeat:
n/a

Suggested fix:
Add the ability to atleast perform a SHOW CREATE TABLE operation on 1 or more selected tables and get the results in an easy-to-cut-and-paste result that can be saved or copied/pasted somewhere for backup reasons.
[27 Jun 2005 0:32] Mark McAulay
It looks like I made a similar request to you.
http://bugs.mysql.com/bug.php?id=6905

It would be handy.
[27 Jun 2005 10:00] Michael G. Zinner
If you open a script tabsheet with Ctrl+Shift+T you can drag all selected tables onto the script tab.

This will give you a create script. 

The also works for views and SPs.

You can also select "Copy SQL to clipboard" from the popup menu in the schema tree. That will copy the same script into the clipboard and you can execute it in a different application.

Please report if this is the functionality you are asking for.

Thanks.
[27 Jul 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".