How do you change a table's schema?

Question

We have a MySQL Workbench project with two tabs (two schemas/two databases).

• If we create a table in the first tab, it's attached to the schema magikweb_dev_igcweb.
• If we create a table in the second tab, it's attached to the schema magikweb_dev_igcweb_archive.

If we copy-paste/duplicate a table from the first tab to the second tab, the resulting table remains in the first schema. How can you change a table's schema?

Each schema is linked with a specific database, so when we use the "Synchronize Model..." feature, it links all the tables properly.

Answer 1

Follow this simple steps (never miss step 4 and 5) :

1. Open Model Tab

2. Choose source schema. In my case, I want to copy table users from schema abc_develop_v1 to schema abc_develop_v2 then paste to diagram . So I choose schema abc_develop_v1, right-click table users then Copy 'users'

3. Go to the targeted schema. In my case is schema abc_develop_v2, right-click then Paste 'users'

4. Next, copy table users from schema abc_develop_v2. Right-click table users then Copy 'users'

5. Go to your diagram and Paste 'users'.

That's all. Your table is ready in your diagram with the right schema :-)

Notes: You can double check by double-click on the table in your diagram, and look at the right corner. It will show the Schema name.

Answer 2

Use the model tab. You can cut out a table from one schema tab and insert it into another.