Bug #69560 The generated SQL script to drop table and schema uses lowercase
Submitted: 24 Jun 2013 17:22 Modified: 11 Jul 2013 0:22
Reporter: Franck Dernoncourt Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.47 OS:Windows
Assigned to: CPU Architecture:Any
Tags: case

[24 Jun 2013 17:22] Franck Dernoncourt
When right clicking on a table or a schema and selecting drop table/schema, the generated SQL script uses lower case, e.g. "drop table `phpmyadmin`.`pma_bookmark`;". It should be "DROP TABLE `phpmyadmin`.`pma_bookmark`;" to be consistent with the SQL generated when altering a table, which uses uppercase, as well as with the ANSI standard http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt. Demo: http://youtu.be/Sk84zkFZjMg

How to repeat:
Right clicking on a table or a schema and select drop table/schema.

Suggested fix:
Use uppercase.
[24 Jun 2013 17:25] Franck Dernoncourt
Sorry I forgot to finish writing the title, and there doesn't seem any way for me to edit my original bug report.
[24 Jun 2013 18:22] Franck Dernoncourt
Change tittle
[25 Jun 2013 1:37] MySQL Verification Team
Thank you for the bug report.
[11 Jul 2013 0:22] Philip Olson
Fixed as of MySQL Workbench 6.0.3 (BETA 2), and here's the changelog entry:

The "SELECT DROP table/schema" context menu action would generate SQL in
lowercase. SQL keywords are now written in uppercase.

Thank you for the bug report.