Alter Table Case Insensitive To Column Name Changes

[GrayChipper]

When you open Alter Table screen, if you only change the case of a column name, alter table will not detect a change nor try to update the table.

I inherited a database with mixed case column names. When attempting to alter the table and change the column name to lower case, I can not use the Alter Table tool as it wont detect my change. Eg. Original column name = Company_Name, retyped in Alter Table=company_name. But, Alter Table tool, doesn't see the difference and create a alter table statement.

In using version 9.51

[ashwin]

Hi,

Quote:

When you open Alter Table screen, if you only change the case of a column name, alter table will not detect a change nor try to update the table.

This issue has been fixed in 9.6 Beta2. Refer: http://www.webyog.com/blog/2012/02/02/sqlyog-mysql-gui-9-6-beta-2-released/ Anyway you can try the latest beta- http://www.webyog.com/blog/2012/02/08/sqlyog-mysql-gui-9-6-beta-3-released/ Stable build(9.6 GA) will be available in the next week.

Regards,

Ashwin A

[Author]

Posts