Bug #9790 "Copy SQL to Clipboard" on view generates "Drop Table"
Submitted: 10 Apr 2005 12:26 Modified: 27 Apr 2005 20:54
Reporter: Eyal Peleg Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.6 OS:Windows (XP Pro SP2)
Assigned to: Michael G. Zinner CPU Architecture:Any

[10 Apr 2005 12:26] Eyal Peleg 
Description:
After I created a View
I right clicked it on the scemata tab and selected "Copy SQL to Clipboard",
the copied SQL was started with 

DROP TABLE IF EXISTS `mydb`.`myview`;

when I would have expected to to be:

DROP VIEW IF EXISTS `mydb`.`myview`;

How to repeat:
Create a view on some table.
right click on it and select copy SQL to clipboard

paste to script editor

Suggested fix:
make it reurn a DROP VIEW statement
instead of a DROP TABLE one.
[27 Apr 2005 20:54] Michael G. Zinner 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html