Bug #62503 Moving columns between tables
Submitted: 22 Sep 2011 19:40 Modified: 6 Dec 2012 0:42
Reporter: Анатолий Кирсанов Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:5.2.34 OS:Windows
Assigned to: CPU Architecture:Any

[22 Sep 2011 19:40] Анатолий Кирсанов
Description:
Occasionally a created several columns in wrong table. There is no possibility to move (e.g. cut and paste or drag-n-drop) columns between tables.

How to repeat:
1. Open some EER model in Workbench.
2. Open some diagram in t it containing at least two tables.
3. Double click on some table. Properties windows with several tabs opens. There are Table, Columns, Indexes, Foreign keys, Triggers, Partitioning, Options, Inserts, Priviliges. 
4. Select Columns tab an create some (two or more) columns.

5. Imagine that you created these columns in wrong table (you should double click another table in this diagram).

6. You can't cut these columns and paste them into another table column list!!!

Suggested fix:
Minimum variant:

1. Select several columns in column list (left mouse button, e.g. while Ctrl pressed).
2. Press right mouse button and select Cut or Copy command in context menu.

3. Double click on another table and select Column tab.
4. Press right mouse button on some column and select Paste command in context menu.

Maximum variant:

Using graphical tables and columns representation in diagram (without double clicking on tables) and drag-n-drop.
[23 Sep 2011 6:54] Valeriy Kravchuk
Thank you for the feature request.
[3 Nov 2012 15:53] Alfredo Kojima
Bug #45134 marked as a duplicate
[6 Dec 2012 0:42] Philip Olson
Fixed as of the upcoming MySQL Workbench 5.2.45, and here's the changelog entry:

Copy, Cut, and Paste options were added to the context menu (right-click)
of the "Columns" list in the models table editor. These options can be
used between models.

The related documentation has also been updated to reflect this change.

Thank you for the bug report.